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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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?

G.
%----------------------- cut here -----------------------%
\end

----- 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

Responses

Browse pgsql-sql by date

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