problem with date cast

From: andrea gelmini <andrea(dot)gelmini(at)linux(dot)it>
To: pgsql-bugs(at)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: problem with date cast
Date: 2002-05-27 16:21:28
Message-ID: 20020527162128.GA30815@linux.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

hi all,
with latest cvs version of pg i've found this problem:

ns:/tmp> createdb gino
CREATE DATABASE
ns:/tmp> psql gino
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

gino=# create table test (date date, timestamp timestamp);
CREATE TABLE
gino=# insert into test values ('now','now');
INSERT 32101 1
gino=# \x
Expanded display is on.
gino=# select *,date::date as right,timestamp::date as wrong from test ;
-[ RECORD 1 ]-------------------------
date | 27/05/2002
timestamp | 27/05/2002 18:17:30,577187
right | 27/05/2002
wrong | 01/01/2000

am i missing something?

some info:
Linux ns 2.4.18-pre9-ac4 #1 lun feb 18 14:24:51 CET 2002 i686 unknown
debian (sid)
PostgreSQL 7.3devel on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.1
(Debian)

all regression tests passed.

thanks a lot for your work,
andrea gelmini

--
Jesus died for your sins. Make it worth his time.

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-05-27 16:59:25 Re: Documentation regarding %ROWTYPE in PL/PgSQL
Previous Message Mathieu Arnold 2002-05-27 12:36:08 Re: pg_dump && aggregate bug