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
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|