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
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.