return error from date_part

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: return error from date_part
Date: 2001-03-23 19:34:26
Message-ID: 200103231934.f2NJYQ788530@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Antonio Murillo (toni-m(at)usa(dot)net) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
return error from date_part

Long Description
I've Postgres 7.02, run in Linux "RedHat 7.0 i386".
When I have a specific select, only whitch this date return a error.

"SELECT date_part('day',fecha) AS day FROM fecha;

day | fecha
-----+------------
24 | 2001-03-25
(1 row)

Sample Code
SET DATESTYLE TO 'European';
CREATE TABLE "fecha" (
"idfecha" int4 NOT,
"fecha" date
);
INSERT into fecha (idfecha,fecha) VALUES(1,'25/3/2001');
SELECT date_part('day',fecha) AS day FROM fecha;

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2001-03-23 20:27:36 Re: return error from date_part
Previous Message Tom Lane 2001-03-23 16:32:03 Re: Compile fail on 7.1b6 on cygwin with --enable-cassert