Could you please stop with your replies that contribute absolutely nothing to the discussion. Mark
----- Bericht beantwoorden ----- Van: "[email protected] [firebird-support]" <[email protected]> Aan: "[email protected]" <[email protected]> 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' [email protected] [firebird-support]" <[email protected]> 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: "[email protected] [firebird-support]" <[email protected]>Aan: <[email protected]>Onderwerp: [firebird-support] SQL standard for sort fields and returned fieldsDatum: 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: <[email protected]> ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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
