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/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers