Re: null values / partial indices - Mailing list pgsql-hackers

From Mario Weilguni
Subject Re: null values / partial indices
Date
Msg-id 4D618F6493CE064A844A5D496733D6670391B2@freedom.icomedias.com
Whole thread Raw
In response to null values / partial indices  ("Mario Weilguni" <mario.weilguni@icomedias.com>)
List 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


pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: null values / partial indices
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: RC1?