Re: Function proposal to find the type of a datum - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Function proposal to find the type of a datum
Date
Msg-id 25763.1170400671@sss.pgh.pa.us
Whole thread Raw
In response to Re: Function proposal to find the type of a datum  ("Pavel Stehule" <pavel.stehule@hotmail.com>)
Responses Re: Function proposal to find the type of a datum  (Kate F <kate@cats.meow.at>)
List 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 by date:

Previous
From: David Fetter
Date:
Subject: Re: writing new regexp functions
Next
From: Kate F
Date:
Subject: Re: Function proposal to find the type of a datum