| From: | Glen Eustace <geustace(at)godzone(dot)net(dot)nz> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Wht the SEQ Scan ? |
| Date: | 2002-09-15 00:29:47 |
| Message-ID: | 1032049787.22255.14.camel@agree-6 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roy P. Ammeraal | 2002-09-15 02:51:50 | Error compiling tab-complete |
| Previous Message | Stephan Szabo | 2002-09-15 00:20:15 | Re: Wht the SEQ Scan ? |