Re: Query doesn't work anymore on 7.2

Well, thanks! I've got to RTFM next time. Anyway, before reading your message, I had just submitted a bug report :~

[]s
Ricardo.

PS: You're right, I indeed upgraded in 10 minutes :-)

> ---------- Incio da mensagem original -----------
> De: Thomas Lockhart <thomas(at)fourpalms(dot)org>
> Para: ricardorsj(at)uol(dot)com(dot)br
> Cc: pgsql-general(at)postgresql(dot)org
> Data: 26/Feb/2002-05:36
> Assunto: Re: [GENERAL] Query doesn't work anymore on 7.2
>
>>> Hello there. I've just upgraded to pgsql 7.2 on netbsd and one of my programs stopped working because of a parser error:
>> carteirinhas=# insert into registros values (1234,'Teste','A','Teste',date('now'),time('now'),false);
>> ERROR: parser: parse error at or near "'"
>> Although it's clear that this program was done in 10 minutes, it was working on 7.1.3. Has something changed or it seems to be a bug in 7.2's parser?
>
>You also upgraded in 10 minutes ;)
>
>The release notes explicitly mention syntax changes to support SQL9x
>date/time precision features. In particular, "time(p)" is now not
>recognized as a function call but rather as a specifier for the type
>"time" with a precision of "p". You can rewrite your query using
>standard SQL9x syntax (which was also available in versions prior to
>7.2):
>
> insert into registros
> values (1234,'Teste','A','Teste',date 'now',time 'now',false);
>
>In general, you know and I know that PostgreSQL uses functions of the
>form "type(src)" to do type conversions, but it is usually better to use
>standard SQL to actually write your queries. The two forms of literal
>coersion for a string to a type which SQL9x defines are:
>
> type 'string'
> cast('string' as type)
>
>where SQL9x defines the first form as applying to date/time literals
>only while PostgreSQL extends this to all data types.
>
>hth
>
> - Thomas
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html
>

---
UOL: o melhor da Internet.