RE: [HACKERS] Counting bool flags in a complex query
От | Ansley, Michael |
---|---|
Тема | RE: [HACKERS] Counting bool flags in a complex query |
Дата | |
Msg-id | 1BF7C7482189D211B03F00805F8527F70ED04A@S-NATH-EXCH2 обсуждение исходный текст |
Список | pgsql-sql |
Sorry guys, this line: >> ORDER BY (if(folderid < 0) then return(abs(folderid)) else >> return(folderid+max(abs(MIN(folderid))))) Should have read: ORDER BY (if(folderid < 0) then return(abs(folderid)) else return(folderid+abs(MIN(folderid)))) The max was an error. MikeA >> >> Why don't you adjust the ids of your system folders, such >> that they are >> ordered properly? You should have a fixed number of system >> folders, so you >> can guarantee the ids that they will receive. So make the >> Inbox -4. Then >> you just order by folder id, ascending. -4 comes first, >> with the user >> folders always coming after the system folders. >> >> Alternatively, you can sort by an expression, something like: >> >> ORDER BY (if(folderid < 0) then return(abs(folderid)) else >> return(folderid+max(abs(MIN(folderid))))) >> >> What this does is shift all the ids up to ensure that they >> all fall into the >> positive range, while inverting the order of the negative >> ids, which seems
В списке pgsql-sql по дате отправления: