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

date style bug

From: Felipe Alvarez Harnecker <felipe(at)qlsoft(dot)cl>
To: pgsql-bugs(at)postgresql(dot)org
Subject: date style bug
Date: 2001-07-17 16:24:03
Message-ID: 15188.26275.88216.779053@qlsoft.cl (view raw or flat)
Thread:
Lists: pgsql-bugs

Hi,

I'm having this bug ramdonly, some time with a "vacuum analyze" goes
away but not always

here the info:



obelix3=> select version();
                            version                            
---------------------------------------------------------------
 PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.95.2
(1 row)


obelix3=> set datestyle=postgres,us;
SET VARIABLE

obelix3=> select * from orden_visita where fecha_emision <= 'today'::date;
 numero | corredor | ejecutivo |  remoto   |  cliente  |  retira   | tipo_operac
ion | fecha_emision 
--------+----------+-----------+-----------+-----------+-----------+------------
----+---------------
    292 | 78626380 |   6607775 | 127.0.0.1 |   8779524 |   8779524 |
Venta 

QUERY RUNS OK.

obelix3=> set datestyle=postgres,euro;
SET VARIABLE


obelix3=> select * from orden_visita where fecha_emision <= 'today'::date;
ERROR:  Bad date external representation '07-17-2001'


BUG.

Please help me I'm near suicide ...

Thanx.

-- 
______________________________________________________

Felipe Alvarez Harnecker.  QlSoftware.
		
Tels. 665.99.41 - 09.874.60.17
e-mail: felipe(dot)alvarez(at)qlsoft(dot)cl

http://qlsoft.cl/
http://ql.cl/
______________________________________________________

Responses

pgsql-bugs by date

Next:From: Geoff ReedyDate: 2001-07-17 21:45:53
Subject: bug in the money type
Previous:From: Bruce MomjianDate: 2001-07-17 14:09:59
Subject: Re: WIN32 Non Blocking

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