asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steven Jacobs <>
Subject Re: Do we allow optional parameter in a function?
Date Sat, 24 Sep 2016 03:38:46 GMT
The only way we handle this currently is to have two separate function
signatures. They can share code underneath, but we are strict about
parameter count. The other option would be for the user to pass some null
representation for the third value.

On Friday, September 23, 2016, Taewoo Kim <> wrote:

> Hi all,
> Here is my question. Can a function have an optional parameter? For
> example, if a function F requires three parameters  - a, b, c, can we omit
> the last one? F(a,b,c) VS F(a,b). I tried and Asterix says that F(a,b) is
> not defined. If someone knows the workaround, it would be really nice.
> Actual scenario: Full-text search function name is ftcontains() and it has
> three parameters - expresssion1, expression2, options as a record. An
> example is ftcontains($o.title, "database", {"mode":"and"}). I would like
> to give user the option to not put the third parameter. In that case, each
> option can be set using default values.
> Best,
> Taewoo

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message