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/