Skip site navigation (1) Skip section navigation (2)

Re: How do I convice postgres to use an index?

From: "SZUCS Gabor" <surrano(at)mailbox(dot)hu>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: How do I convice postgres to use an index?
Date: 2004-07-19 08:47:40
Message-ID: 050001c46d6d$0fb2dea0$0403a8c0@fejleszt4 (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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?

%----------------------- cut here -----------------------%

----- Original Message ----- 
From: "Achilleus Mantzios" <achill(at)matrix(dot)gatewaynet(dot)com>
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??

In response to


pgsql-sql by date

Next:From: Luis SousaDate: 2004-07-19 09:00:50
Subject: Re: Problem in age on a dates interval
Previous:From: Tom LaneDate: 2004-07-19 04:23:21
Subject: Re: FOR-IN-EXECUTE, why fail?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group