Re: Oracle Decode Function - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Oracle Decode Function
Date
Msg-id 18835.1027611617@sss.pgh.pa.us
Whole thread Raw
In response to Re: Oracle Decode Function  (Marc Lavergne <mlavergne-pub@richlava.com>)
List pgsql-hackers
Marc Lavergne <mlavergne-pub@richlava.com> writes:
> If you're asking about whether a custom function can have vararg 
> parameters, the answer appears to depend on the CREATE FUNCTION
> syntax. 

Can't do it, though you could imagine creating a family of functions
of the same name and different numbers of parameters.  Trying to
emulate DECODE this way would have a much worse problem: what's the
datatype of the parameters?  (Or the result?)

Use CASE; it does more than DECODE *and* is ANSI-standard.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: bug in COPY
Next
From: Hannu Krosing
Date:
Subject: Re: why?