Re: COALESCE and NULLIF semantics - Mailing list pgsql-hackers

From Sam Mason
Subject Re: COALESCE and NULLIF semantics
Date
Msg-id 20090911172909.GQ5407@samason.me.uk
Whole thread Raw
In response to Re: COALESCE and NULLIF semantics  (Sam Mason <sam@samason.me.uk>)
List pgsql-hackers
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/


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: COALESCE and NULLIF semantics
Next
From: Sam Mason
Date:
Subject: Re: COALESCE and NULLIF semantics