X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 10A829258E2 for ; Mon, 26 May 2003 08:43:33 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 69240-08 for ; Mon, 26 May 2003 08:43:32 -0400 (EDT) Received: from spirit.aldeiadigital.com.br (iplus-fac-213-137.xdsl-fixo.ctbcnetsuper.com.br [200.225.213.137]) by developer.postgresql.org (Postfix) with ESMTP id 6D61292589B for ; Mon, 26 May 2003 08:43:30 -0400 (EDT) Received: from webmail.ad2.com.br (localhost.localdomain [127.0.0.1]) by spirit.aldeiadigital.com.br (8.11.6/8.11.6) with SMTP id h4QChvN12544 for ; Mon, 26 May 2003 09:44:03 -0300 Received: from 200.170.145.209 (SquirrelMail authenticated user alepaes) by webmail.ad2.com.br with HTTP; Mon, 26 May 2003 09:44:03 -0300 (BRT) Message-ID: <1288.200.170.145.209.1053953043.squirrel@webmail.ad2.com.br> Date: Mon, 26 May 2003 09:44:03 -0300 (BRT) Subject: timestamp field - select error From: "alexandre :: aldeia digital" To: pgsql-sql@postgresql.org User-Agent: SquirrelMail/1.4.0 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 X-Priority: 3 Importance: Normal X-Virus-Scanned: by amavisd-milter (http://amavis.org/) X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/495 X-Sequence-Number: 13660 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