Bug #603: time() problems with PostgreSQL 7.2 - Mailing list pgsql-bugs

From pgsql-bugs@postgresql.org
Subject Bug #603: time() problems with PostgreSQL 7.2
Date
Msg-id 20020226134338.A3EE5475876@postgresql.org
Whole thread Raw
Responses Re: Bug #603: time() problems with PostgreSQL 7.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Ricardo Ryoiti Sugawara Junior (suga@netbsd.com.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

pgsql-bugs by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: COPY FROM is not 8bit clean
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #604: string join problem