Re: Function proposal to find the type of a datum

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Function proposal to find the type of a datum
Дата
Msg-id 25763.1170400671@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Function proposal to find the type of a datum  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
Ответы Re: Function proposal to find the type of a datum
Список pgsql-hackers
"Pavel Stehule" <pavel.stehule@hotmail.com> writes:
> you can identify type via operator OF.

>   IF a IS OF INTEGER THEN
>     RAISE NOTICE 'Parametr a is numeric';

Yeah, that is the SQL-standard syntax, but I think our implementation
doesn't work the way Kate would like: if "a" is an ANYELEMENT function
parameter then (I think) only IS OF ANYELEMENT would succeed.  Would it
conform to the SQL spec for the test to "look through" ANYELEMENT to the
actual parameter type?  Would it be reasonably implementable to do that?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: writing new regexp functions
Следующее
От: Kate F
Дата:
Сообщение: Re: Function proposal to find the type of a datum