Re: polymorphic SQL functions has a problem with domains

2014-04-02 18:34 GMT+02:00 David Johnston <polobo(at)yahoo(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
>