FAQ

On 20 August 2013 11:46, Jani Tiainen 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+unsubscribe@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.

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 7 | next ›
Discussion Overview
groupdjango-users @
categoriesdjango, python
postedAug 19, '13 at 7:39a
activeAug 20, '13 at 5:08p
posts7
users5
websitedjangoproject.com

People

Translate

site design / logo © 2017 Grokbase