Re: polymorphic SQL functions has a problem with domains

Поиск
Список
Период
Сортировка
От Pavel Stehule
Тема Re: polymorphic SQL functions has a problem with domains
Дата
Msg-id CAFj8pRB=RMfwtUcvKTPch76G3mywcb7J-wAqEuE0_yKgyzfTvA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: polymorphic SQL functions has a problem with domains  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: polymorphic SQL functions has a problem with domains
Следующее
От: Andres Freund
Дата:
Сообщение: Re: polymorphic SQL functions has a problem with domains