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) We now have workarounds in place for everywhere this bit us on conversion to PostgreSQL, but it was actually one of the greater sources of pain in that process.... -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers