Kate F <kate(at)cats(dot)meow(dot)at> writes:
> ... OF takes a list of types; it needs parentheses:
>     IF a IS OF (INTEGER) THEN

Oh, right, minor detail.

> Meanwhile, I still think the function David proposed is a worthy
> addition (and I still have a user-case for it!), as using just the OF
> operator for something similar, one would have to explictly test
> against every type required.

Um, but what would you do differently with an OID result?  The nice
thing about the SQL-spec syntax is that it avoids depending on anything
so implementation-specific as a pg_type OID.  So if it covers the
territory then I'd be inclined to go that way.  What useful
functionality does it lack?

			regards, tom lane

In response to

• Re: Function proposal to find the type of a datum at 2007-02-02 07:17:51 from Tom Lane

Responses

• Re: Function proposal to find the type of a datum at 2007-02-02 07:51:08 from Kate F

pgsql-hackers by date

Next:	From: Pavel Stehule	Date: 2007-02-02 07:47:22
	Subject: ToDo: add documentation for operator IS OF
Previous:	From: Kate F	Date: 2007-02-02 07:31:13
	Subject: Re: Function proposal to find the type of a datum