Re: Wht the SEQ Scan ? - Mailing list pgsql-general

From Glen Eustace
Subject Re: Wht the SEQ Scan ?
Date
Msg-id 1032049787.22255.14.camel@agree-6
Whole thread Raw
In response to Re: Wht the SEQ Scan ?  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
On Sun, 2002-09-15 at 12:20, Stephan Szabo wrote:
> The one in this case is probably the smallint/bigint problem with
> constants being converted to int4 when unquoted.
> Try client='10143' or client=CAST(10143 as smallint) in the where
> clauses instead of client=10143 and see if that gives you usage of the
> index.

Brilliant, got it in one.

Thanks.

--

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand 5301
Ph/Fax: +64 6 357 8168, Mob: +64 21 424 015



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Wht the SEQ Scan ?
Next
From: Justin Clift
Date:
Subject: Anyone remember the name of the PostgreSQL GUI installer that Great Bridge started?