X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9DF8DD1B1CE for ; Mon, 19 Jul 2004 05:48:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27321-10 for ; Mon, 19 Jul 2004 08:48:28 +0000 (GMT) Received: from fe07.axelero.hu (fe07.axelero.hu [195.228.240.95]) by svr1.postgresql.org (Postfix) with ESMTP id 1DECDD1B1BE for ; Mon, 19 Jul 2004 05:48:22 -0300 (ADT) Received: from fe07 (localhost-02 [127.0.2.1]) by fe07.axelero.hu (8.12.11/8.12.11) with SMTP id i6J8mN5Z082995 for ; Mon, 19 Jul 2004 10:48:23 +0200 (CEST) Received: from fe07.axelero.hu [127.0.2.1] via SMTP gateway by fe07 [195.228.240.95]; id A043FB81D47 at Mon, 19 Jul 2004 10:48:21 +0200 Received: from fejleszt4 (121-248-182-81.adsl-fixip.axelero.hu [81.182.248.121]) by fe07.axelero.hu (8.12.11/8.12.11) with SMTP id i6J8mEFp082689 for ; Mon, 19 Jul 2004 10:48:18 +0200 (CEST) Message-ID: <050001c46d6d$0fb2dea0$0403a8c0@fejleszt4> From: "SZUCS Gabor" To: References: Subject: Re: How do I convice postgres to use an index? Date: Mon, 19 Jul 2004 10:47:40 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-7" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-RAVMilter-Version: 8.4.3(snapshot 20030217) (fe07.axelero.hu) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/115 X-Sequence-Number: 18367 re-checked; it's WITHOUT in both version, but it's irrelevant if you give the full spec. Well, then maybe it was a difference between 7.2 and 7.3, but again, it's irrelevant in your case. Have you tried the typecast? G. %----------------------- cut here -----------------------% \end ----- Original Message ----- From: "Achilleus Mantzios" Sent: Thursday, July 15, 2004 4:00 PM > > Also, I'd try to avoid naming attributes like (built-in) types. (iirc > > "timestamp" is a type without time zone in 7.3, and with time zone in 7.4 :) > ^^^^^^^^^^^^^^^^^^^^^^ > > Are you sure about it??