On 20 August 2013 11:46, Jani Tiainen <rede...@gmail.com> wrote: > I think pretty latest PostgreSQL can use indexes to filter NULL values as > well (doesn't have facility to store them though).
Postgres can use an index to find NULL values, so SELECT * FROM foo WHERE col IS NULL can be indexed. Not sure what you mean by "doesn't have facility to store them". NULL values are stored in the database, they just don't occupy the same space as non-NULL values. PostgreSQL's support of NULL values is full and complete, in line with SQL Standard requirements. > MySQL uses table statistics to determine are NULL values indexed or not. Postgres stats include number of values NULL. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscr...@googlegroups.com. To post to this group, send email to django-users@googlegroups.com. Visit this group at http://groups.google.com/group/django-users. For more options, visit https://groups.google.com/groups/opt_out.
