"Kevin Grittner" <kevin.gritt...@wicourts.gov> writes:
> Peter Eisentraut <pete...@gmx.net> wrote:
>> reimplement a bunch of core functionality like COALESCE
> If such an effort could reduce the astonishment factor for the
> following, it would justify a certain amount of effort, in my view:
> test=# select pg_typeof('x');
> pg_typeof
> -----------
> unknown
> (1 row)
> test=# select pg_typeof(null);
> pg_typeof
> -----------
> unknown
> (1 row)
> test=# select pg_typeof(coalesce(null, null));
> pg_typeof
> -----------
> text
> (1 row)
The astonishment factor there has nothing to do with how the behavior is
inserted into the parser; it's a property of our type resolution rules.
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
