> 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