Ricardo Ryoiti Sugawara Junior (suga(at)netbsd(dot)com(dot)br) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
time() problems with PostgreSQL 7.2
Long Description
time('now') used to work but it doesn't work anymore in PostgreSQL 7.2.
Sample Code
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=# select time('now');
ERROR: parser: parse error at or near "'";
No file was uploaded with this report