"Kevin Grittner" <[EMAIL PROTECTED]> writes:
> [ "coalesce(null, null)" yields type TEXT ]
Well, it has to yield *something*. You'd get the same result from
"coalesce('2006-11-29', '2006-11-30')" ... you might think this looks
like dates, but it's just some untyped literals and the parser chooses
Here is sample code demonstrating the issue:
test=# create table test_coalesce(f1 int not null, f2 date);
CREATE TABLE
test=# insert into test_coalesce values (1, null);
INSERT 0 1
test=# insert into test_coalesce values (2, coalesce(null, null));
ERROR: column "f2" is of type date but expressio
