Re: polymorphic SQL functions has a problem with domains - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: polymorphic SQL functions has a problem with domains
Date
Msg-id CAFj8pRB=RMfwtUcvKTPch76G3mywcb7J-wAqEuE0_yKgyzfTvA@mail.gmail.com
Whole thread Raw
In response to Re: polymorphic SQL functions has a problem with domains  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers



2014-04-02 18:27 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us>:
David Johnston <polobo@yahoo.com> writes:
> Does something like:
> SELECT ($1 + $2)::$1%TYPE
> exist where you can explicitly cast to the type of the input argument?

I don't think SQL-language functions have such a notation, but it's
possible in plpgsql, if memory serves.


No, this possibility doesn't there, what I know.

but you can do assignment to some output variable - what is effective same

Pavel
 
                        regards, tom lane


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: polymorphic SQL functions has a problem with domains
Next
From: Andres Freund
Date:
Subject: Re: polymorphic SQL functions has a problem with domains