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: 20020226134338.A3EE5475876@postgresql.org (view raw or flat)
Thread:
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


Responses

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-2014 The PostgreSQL Global Development Group