Re: null values / partial indices

From: "Mario Weilguni" <mario(dot)weilguni(at)icomedias(dot)com>
To: "Zeugswetter Andreas SB SD" <ZeugswetterA(at)spardat(dot)at>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: null values / partial indices
Date: 2002-11-13 13:09:34
Message-ID: 4D618F6493CE064A844A5D496733D6670391B2@freedom.icomedias.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>You can try an index like:
>create index str_idx_url on str(url) where url >= '';
>
>I think that should be identical. ('' is the smallest string, no ?)

Thanks alot, it works now. But I still think the NOT NULL case would be
useful.

Best regards,
Mario Weilguni

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB SD 2002-11-13 13:23:11 Re: RC1?
Previous Message Zeugswetter Andreas SB SD 2002-11-13 13:02:16 Re: null values / partial indices