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 D91DF9258E1 for ; Mon, 26 May 2003 16:19:01 -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 84550-03 for ; Mon, 26 May 2003 16:19:01 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id A91FA9258CD for ; Mon, 26 May 2003 16:19:00 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4QKIrU6005519; Mon, 26 May 2003 16:18:53 -0400 (EDT) To: "alexandre :: aldeia digital" Cc: pgsql-sql@postgresql.org Subject: Re: timestamp field - select error In-reply-to: <1255.192.168.1.101.1053976667.squirrel@webmail.ad2.com.br> References: <1288.200.170.145.209.1053953043.squirrel@webmail.ad2.com.br> <3967.1053972532@sss.pgh.pa.us> <1255.192.168.1.101.1053976667.squirrel@webmail.ad2.com.br> Comments: In-reply-to "alexandre :: aldeia digital" message dated "Mon, 26 May 2003 16:17:47 -0300" Date: Mon, 26 May 2003 16:18:53 -0400 Message-ID: <5518.1053980333@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/501 X-Sequence-Number: 13666 "alexandre :: aldeia digital" writes: > Really the field is a Domain (datetime = timestamp without timezone). Ah. Okay, then the reason I don't see it is I have this 7.3.3 patch: 2003-03-22 20:49 tgl * src/backend/: optimizer/path/indxpath.c, utils/adt/selfuncs.c (REL7_3_STABLE): Tweak selectivity and related routines to cope with domains. Per report from Andreas Pflug. regards, tom lane