Re: COALESCE and NULLIF semantics

On Fri, Sep 11, 2009 at 06:24:22PM +0100, Sam Mason wrote:
> One thing I've just realized these discussions have pointed out is
> that PG isn't doing the correct thing all the time with types. When
> is it ever valid to see an "unknown" after type checking? AFAICT, it
> shouldn't ever appear and hence doing:
>
> CREATE VIEW v AS SELECT 'foo';
>
> Should be doing the normal default to TEXT type. Is that right? or does
> "unknown" have more meaning besides just being something that needs to
> be fixed up during type checking.

Doh, sorry I shouldn't have sent that. I wanted to spend some time to
see if I could find any other examples, but I hit send by accident.

--
Sam http://samason.me.uk/