Subject Re: [firebird-support] SQL standard for sort fie lds and returned fields
Author Mark Rotteveel
Could you please stop with your replies that contribute absolutely nothing to the discussion.

Mark


----- Bericht beantwoorden -----
Van: "kristinwensley@... [firebird-support]" <firebird-support@yahoogroups.com>
Aan: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>
Onderwerp: [firebird-support] SQL standard for sort fields and returned fields
Datum: ma, mei 9, 2016 23:54

Perfect


On Monday, May 9, 2016 8:48 PM, "'Mark Rotteveel' mark@... [firebird-support]" <firebird-support@yahoogroups.com> wrote:


 
Ah. It is the exception, because ordering by column index (en order by 1, 3) uses the index of the column in the select list, so by definition that column needs to be in the list.

Mark


----- Bericht beantwoorden -----
Van: "liviuslivius@... [firebird-support]" <firebird-support@yahoogroups.com>
Aan: <firebird-support@yahoogroups.com>
Onderwerp: [firebird-support] SQL standard for sort fields and returned fields
Datum: ma, mei 9, 2016 21:40

Hi,
i am talking about your post 
“I don't have the SQL standard at hand right now, so I can't double 
check. As far as I know, the SQL standard allows you to sort on any 
field, even if it is not in the select list (with the exception of 
course of ordering by column index).”

and about line “with the exception of course of ordering by column index”


regards,
Karol Bieniaszewski


>>I see no exception, did you try to include an image in your e-mail? >>Please post query + error message as text instead. >>Mark
[Non-text portions of this message have been removed] ------------------------------------ Posted by: <liviuslivius@...> ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-digest@yahoogroups.com firebird-support-fullfeatured@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscribe@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/