CREATE INDEX with NULLS FIRST/LAST options
------------------------------------------
Key: CORE-4266
URL: http://tracker.firebirdsql.org/browse/CORE-4266
Project: Firebird Core
Issue Type: New Feature
Reporter: Attila Molnár
Priority: Minor
Hi!
Currently ORDER BY with ASC <fieldname> NULLS LAST cannot use either ASC or
DESC index.
It would be great to specify NULLS/FIRST LAST for fields when create an index,
and in this case index usage would be possible.
CREATE [UNIQUE] [ASC[ENDING] | [DESC[ENDING]] INDEX indexname
ON tablename
{ (<col> [NULLS FIRST/LAST] [, <col> [NULLS FIRST/LAST]...]) | COMPUTED BY
(expression) }
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
DreamFactory - Open Source REST & JSON Services for HTML5 & Native Apps
OAuth, Users, Roles, SQL, NoSQL, BLOB Storage and External API Access
Free app hosting. Or install the open source package on any LAMP server.
Sign up and see examples for AngularJS, jQuery, Sencha Touch and Native!
http://pubads.g.doubleclick.net/gampad/clk?id=63469471&iu=/4140/ostg.clktrk
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
