| From: | ricardorsj(at)uol(dot)com(dot)br | 
|---|---|
| To: | pgsql-general(at)postgresql(dot)org | 
| Subject: | Query doesn't work anymore on 7.2 | 
| Date: | 2002-02-26 12:01:03 | 
| Message-ID: | 200202261201.JAA10996@walters.uol.com.br | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-general | 
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=# \d registros
               Table "registros"
  Column   |          Type          | Modifiers
-----------+------------------------+-----------
 matricula | integer                |
 resp      | character varying(50)  |
 tipo      | character(1)           |
 nome      | character varying(50)  |
 data      | date                   |
 hora      | time without time zone |
 baixa     | boolean                |
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?
[]'s
Ricardo.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Janning Vygen | 2002-02-26 12:02:05 | Sql basic Query | 
| Previous Message | Martijn van Oosterhout | 2002-02-26 08:17:04 | Re: transaction abortion |