any way for ORDER BY x to imply NULLS FIRST in 8.3?

From: rihad <rihad(at)mail(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: any way for ORDER BY x to imply NULLS FIRST in 8.3?
Date: 2007-11-06 07:38:29
Message-ID: 473019F5.1010702@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there any way to "hardcode" the NULL handling in an index (as per
http://www.postgresql.org/docs/8.3/static/indexes-ordering.html) so that
SELECT * FROM t ORDER BY foo automatically implies NULLS FIRST (and,
similarly so that SELECT * FROM t ORDER BY foo DESC automatically
implies NULLS LAST)? Thing is, I'm using PHP Symfony/Propel to generate
their SQL and have no easy way to influence how they do so.

Thanks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-11-06 08:23:12 Re: php and postgres - too many queries too fast?
Previous Message Pavel Stehule 2007-11-06 07:33:35 Re: for libpq which include defines the type oids