Postgres Pro
Downloads
Home   >   mailing lists

Index on nullable column - Mailing list pgsql-sql

From Daniel Caune
Subject Index on nullable column
Date
Msg-id 1E293D3FF63A3740B10AD5AAD88535D201DA051D@UBIMAIL1.ubisoft.org
Whole thread Raw
Responses Re: Index on nullable column
List pgsql-sql
Tree view 
Hi,

Is an index on a nullable column useful for retrieving rows having that
column null?
 SELECT PlayerID   FROM PlayerLoginSession   WHERE EndTime IS NULL;

Regards,


--
Daniel CAUNE
Ubisoft Online Technology
(514) 4090 2040 ext. 5418

pgsql-sql by date:

Previous
From: Amos Hayes
Date:
Subject: Re: Find min and max values across two columns?
Next
From: Stephan Szabo
Date:
Subject: Re: SQL Query Newbie Help