Re: date style bug

Thomas Lockhart writes:
> > I'm having this bug ramdonly, some time with a "vacuum analyze" goes
> > away but not always
>
> Likely not related at all.
>
> > 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.
>
> What is the value of the fecha_emision column? What is the schema?
> >
> > obelix3=> set datestyle=postgres,euro;
> > obelix3=> select * from orden_visita where fecha_emision <= 'today'::date;
> > ERROR: Bad date external representation '07-17-2001'
>
> What is the schema? I'll guess that fecha_emision is not actually a date
> type (either date or timestamp) but rather a text field. That is the
> only way I can think of to provoke an "external representation" error.
>
> More details please.
>
> - Thomas
>

Here is it:
-------------

obelix3=> \d orden_visita
Table "orden_visita"
Attribute | Type | Modifier
----------------+---------+-----------------------------------------------------------
numero | integer | not null default nextval('orden_visita_numero_seq'::text)
corredor | integer | not null
ejecutivo | integer | not null
remoto | inet | not null
cliente | integer | not null
retira | integer | not null
tipo_operacion | text | not null default 'Arriendo'
fecha_emision | date | default date("timestamp"('now'::text))
Index: orden_visita_pkey

--
______________________________________________________

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/
______________________________________________________