SQLite.swift icon indicating copy to clipboard operation
SQLite.swift copied to clipboard

Add order by NULLS FIRST/LAST

Open kooliokey opened this issue 8 years ago • 1 comments

Would be great to have the ability to add custom expressions so we can add different things that aren't covered in the library already. For example, I need to run a ORDER BY "fieldName" IS NULL, but there is no such expression available for the fields. Is there another way to do this without running custom SQL?

kooliokey avatar Nov 05 '16 01:11 kooliokey

SQLite 3.30.0 supports NULLS FIRST and NULLS LAST, so this should probably be added instead

https://sqlite.org/lang_select.html

jberkel avatar Aug 24 '21 17:08 jberkel