asterixdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Taewoo Kim <wangs...@gmail.com>
Subject Re: Do we allow optional parameter in a function?
Date Sun, 25 Sep 2016 01:29:20 GMT
@Steven: Thanks for the information. I think two separate function
signatures would be better instead let use say F(a,b,null).

Best,
Taewoo

On Fri, Sep 23, 2016 at 8:38 PM, Steven Jacobs <sjaco002@ucr.edu> wrote:

> 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.
> Steven
>
> On Friday, September 23, 2016, Taewoo Kim <wangsaeu@gmail.com> 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
> >
>

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