Re: Question about index usage

From: Guido Neitzer <guido(dot)neitzer(at)pharmaline(dot)de>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Cc: chris smith <dmagick(at)gmail(dot)com>
Subject: Re: Question about index usage
Date: 2006-03-07 11:17:12
Message-ID: DD2387EA-0728-4780-BCA6-AC92741327F7@pharmaline.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07.03.2006, at 12:09 Uhr, chris smith wrote:

> Try without the quotes:
>
> select id from dga_dienstleister where plz in (45257, 45259);

Same result, second index is used.

> What is the table structure for dga_dienstleister ?

For the relevant column:

plz | character varying(256) |
not null

Thanks,
cug

--
PharmaLine, Essen, GERMANY
Software and Database Development

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Guido Neitzer 2006-03-07 11:55:29 Re: Logging seq scans
Previous Message Martijn van Oosterhout 2006-03-07 11:13:59 Re: REPOST: How to determine the table a query or a views columns come from?