View Single Post
Old 06-23-2011, 05:21 PM   #25
Mackx
Guru
Mackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to beholdMackx is a splendid one to behold
 
Posts: 998
Karma: 19985
Join Date: Dec 2008
Location: Netherlands
Device: iRex DR1000S
Looking at libermetadb I see the following is used (when sorting on filename):
Code:
ORDER BY
    sort_priority DESC,
    (CASE WHEN filename IS NOT NULL THEN 0 ELSE 1 END),
    filename COLLATE IREX_CASE_INSENSITIVE,
    directory_path COLLATE IREX_CASE_INSENSITIVE
(sort_priority is used to get folder in front of files.) I am no database expert, so its just for information.
Mackx is offline   Reply With Quote