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 or flat)
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

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-2014 The PostgreSQL Global Development Group