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.alvarez@qlsoft.cl
http://qlsoft.cl/
http://ql.cl/
______________________________________________________
