2014-04-02 18:34 GMT+02:00 David Johnston <pol...@yahoo.com>: > Tom Lane-2 wrote > > David Johnston < > > > polobo@ > > > > 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. > > Indeed. > > > http://www.postgresql.org/docs/9.3/interactive/plpgsql-declarations.html#PLPGSQL-DECLARATION-TYPE >
This casting is indirect via assignment > > Section 40.3.3 > > You lose inlining but at least it (should) work. > > David J. > > > > > > > -- > View this message in context: > http://postgresql.1045698.n5.nabble.com/polymorphic-SQL-functions-has-a-problem-with-domains-tp5798349p5798367.html > Sent from the PostgreSQL - hackers mailing list archive at Nabble.com. > > > -- > Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-hackers >
