timestamp field - select error

From: "alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br>
To: pgsql-sql(at)postgresql(dot)org
Subject: timestamp field - select error
Date: 2003-05-26 12:44:03
Message-ID: 1288.200.170.145.209.1053953043.squirrel@webmail.ad2.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

I have a large table with a timestamp field.

select cf03dthr from cf03t where cf03dthr <= '2003-12-31'::timestamp ORDER
BY cf03dthr DESC LIMIT 3

cf03dthr
---------------------
2003-05-27 01:01:01
2003-05-26 09:50:55
2003-05-26 09:49:54
(3 rows)

(...) where cf03dthr <= '2003-05-27' (...)

cf03dthr
---------------------
2003-05-26 09:52:28
2003-05-26 09:50:55
2003-05-26 09:49:54
(3 rows)

* But if I do: (...) where cf03dthr <= '2003-05-26' (...)
* I get: "ERROR: convert_timevalue_to_scalar: unsupported type 16976"
* This occurs in any other dates...

If I do: (...) where cf03dthr <= '2003-05-26 09:00:00' (...), for example,
the rows returns OK, but <= '2003-05-26 06:00:00' or many other
combinations give me the same error.

Thank´s for any help.

alexandre

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mukta Telang 2003-05-26 12:46:05 Many-to-Many relation
Previous Message Mintoo Lall 2003-05-26 02:48:29 Using UPPER and TRIM (INDEX usage)