From: alexandre :: aldeia digital <alepaes@aldeiadigital.com.br>
To: pgsql-sql@postgresql.org
Subject: timestamp field - select error
Date: Mon, 26 May 2003 09:44:03 -0300 (BRT)
Message-ID: <1288.200.170.145.209.1053953043.squirrel@webmail.ad2.com.br> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: alepaes@aldeiadigital.com.br
Subject: Re: timestamp field - select error
In-Reply-To: <1288.200.170.145.209.1053953043.squirrel@webmail.ad2.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox