AW: [firebird-support] Sorting CTE for List()

2016-04-26 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
-support@yahoogroups.com] Gesendet: Samstag, 23. April 2016 17:36 An: firebird-support@yahoogroups.com Betreff: Re: [firebird-support] Sorting CTE for List() Hi Nikolaus! I've wanted sorting lists in Firebird myself, but to no avail. On http://www.firebirdsql.org/refdocs/langrefupd21-aggrfunc

Re: [firebird-support] Sorting CTE for List()

2016-04-23 Thread setysvar setys...@gmail.com [firebird-support]
Hi Nikolaus! I've wanted sorting lists in Firebird myself, but to no avail. On http://www.firebirdsql.org/refdocs/langrefupd21-aggrfunc-list.html, I read: "The ordering of the list values is undefined" And, surely enough, your ORDER BY doesn't actually contribute to the order of the list -

[firebird-support] Sorting CTE for List()

2016-04-16 Thread 'Nikolaus Kern' parzival1...@gmx.at [firebird-support]
Hello, I am using Firebird 2.5.5. and see following behaiviour: 1. One table is used to get the weekdays in a list 2. The other table is joined to identify those working schedules for these days 3. If the second table has a value in the field ANMERKUNG the sorting order