Re: Question about index usage - Mailing list 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