Peter Eisentraut <peter_e@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