Re: [GENERAL] Automatic type conversion

2009-07-15 Thread Alvaro Herrera
CG wrote: > I could add the explicit type casts, but I'd rather find out what the > nature of the subtle (or not-so-subtle) difference I've stumbled upon > is... It's an intentional change, so adding typecasts is the appropriate solution. -- Alvaro Herrerahttp://

[GENERAL] Automatic type conversion

2009-07-15 Thread CG
I'm in the process of attempting to upgrade from 8.1 to 8.4, and I've been using the uniqueidentifier contrib module for my UUID's ... In 8.1 Postgresql was able to figure out what to do with statements like # SELECT 'Your new UUID is ' || newid();    ?column? ---