Skip site navigation (1) Skip section navigation (2)

Bug #603: time() problems with PostgreSQL 7.2

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #603: time() problems with PostgreSQL 7.2
Date: 2002-02-26 13:43:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
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


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-02-26 13:50:07
Subject: Bug #604: string join problem
Previous:From: Tatsuo IshiiDate: 2002-02-26 12:16:54
Subject: Re: COPY FROM is not 8bit clean

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group