Re: date style bug

> 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