-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
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 -
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