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 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: <[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
#yiv7219158047 #yiv7219158047 -- #yiv7219158047ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv7219158047
#yiv7219158047ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv7219158047
#yiv7219158047ygrp-mkp #yiv7219158047hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv7219158047 #yiv7219158047ygrp-mkp #yiv7219158047ads
{margin-bottom:10px;}#yiv7219158047 #yiv7219158047ygrp-mkp .yiv7219158047ad
{padding:0 0;}#yiv7219158047 #yiv7219158047ygrp-mkp .yiv7219158047ad p
{margin:0;}#yiv7219158047 #yiv7219158047ygrp-mkp .yiv7219158047ad a
{color:#0000ff;text-decoration:none;}#yiv7219158047 #yiv7219158047ygrp-sponsor
#yiv7219158047ygrp-lc {font-family:Arial;}#yiv7219158047
#yiv7219158047ygrp-sponsor #yiv7219158047ygrp-lc #yiv7219158047hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv7219158047
#yiv7219158047ygrp-sponsor #yiv7219158047ygrp-lc .yiv7219158047ad
{margin-bottom:10px;padding:0 0;}#yiv7219158047 #yiv7219158047actions
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv7219158047
#yiv7219158047activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv7219158047
#yiv7219158047activity span {font-weight:700;}#yiv7219158047
#yiv7219158047activity span:first-child
{text-transform:uppercase;}#yiv7219158047 #yiv7219158047activity span a
{color:#5085b6;text-decoration:none;}#yiv7219158047 #yiv7219158047activity span
span {color:#ff7900;}#yiv7219158047 #yiv7219158047activity span
.yiv7219158047underline {text-decoration:underline;}#yiv7219158047
.yiv7219158047attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv7219158047 .yiv7219158047attach div a
{text-decoration:none;}#yiv7219158047 .yiv7219158047attach img
{border:none;padding-right:5px;}#yiv7219158047 .yiv7219158047attach label
{display:block;margin-bottom:5px;}#yiv7219158047 .yiv7219158047attach label a
{text-decoration:none;}#yiv7219158047 blockquote {margin:0 0 0
4px;}#yiv7219158047 .yiv7219158047bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv7219158047
.yiv7219158047bold a {text-decoration:none;}#yiv7219158047 dd.yiv7219158047last
p a {font-family:Verdana;font-weight:700;}#yiv7219158047 dd.yiv7219158047last p
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv7219158047
dd.yiv7219158047last p span.yiv7219158047yshortcuts
{margin-right:0;}#yiv7219158047 div.yiv7219158047attach-table div div a
{text-decoration:none;}#yiv7219158047 div.yiv7219158047attach-table
{width:400px;}#yiv7219158047 div.yiv7219158047file-title a, #yiv7219158047
div.yiv7219158047file-title a:active, #yiv7219158047
div.yiv7219158047file-title a:hover, #yiv7219158047 div.yiv7219158047file-title
a:visited {text-decoration:none;}#yiv7219158047 div.yiv7219158047photo-title a,
#yiv7219158047 div.yiv7219158047photo-title a:active, #yiv7219158047
div.yiv7219158047photo-title a:hover, #yiv7219158047
div.yiv7219158047photo-title a:visited {text-decoration:none;}#yiv7219158047
div#yiv7219158047ygrp-mlmsg #yiv7219158047ygrp-msg p a
span.yiv7219158047yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv7219158047
.yiv7219158047green {color:#628c2a;}#yiv7219158047 .yiv7219158047MsoNormal
{margin:0 0 0 0;}#yiv7219158047 o {font-size:0;}#yiv7219158047
#yiv7219158047photos div {float:left;width:72px;}#yiv7219158047
#yiv7219158047photos div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv7219158047
#yiv7219158047photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv7219158047
#yiv7219158047reco-category {font-size:77%;}#yiv7219158047
#yiv7219158047reco-desc {font-size:77%;}#yiv7219158047 .yiv7219158047replbq
{margin:4px;}#yiv7219158047 #yiv7219158047ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv7219158047 #yiv7219158047ygrp-mlmsg
{font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv7219158047
#yiv7219158047ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv7219158047
#yiv7219158047ygrp-mlmsg select, #yiv7219158047 input, #yiv7219158047 textarea
{font:99% Arial, Helvetica, clean, sans-serif;}#yiv7219158047
#yiv7219158047ygrp-mlmsg pre, #yiv7219158047 code {font:115%
monospace;}#yiv7219158047 #yiv7219158047ygrp-mlmsg *
{line-height:1.22em;}#yiv7219158047 #yiv7219158047ygrp-mlmsg #yiv7219158047logo
{padding-bottom:10px;}#yiv7219158047 #yiv7219158047ygrp-msg p a
{font-family:Verdana;}#yiv7219158047 #yiv7219158047ygrp-msg
p#yiv7219158047attach-count span {color:#1E66AE;font-weight:700;}#yiv7219158047
#yiv7219158047ygrp-reco #yiv7219158047reco-head
{color:#ff7900;font-weight:700;}#yiv7219158047 #yiv7219158047ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv7219158047 #yiv7219158047ygrp-sponsor
#yiv7219158047ov li a {font-size:130%;text-decoration:none;}#yiv7219158047
#yiv7219158047ygrp-sponsor #yiv7219158047ov li
{font-size:77%;list-style-type:square;padding:6px 0;}#yiv7219158047
#yiv7219158047ygrp-sponsor #yiv7219158047ov ul {margin:0;padding:0 0 0
8px;}#yiv7219158047 #yiv7219158047ygrp-text
{font-family:Georgia;}#yiv7219158047 #yiv7219158047ygrp-text p {margin:0 0 1em
0;}#yiv7219158047 #yiv7219158047ygrp-text tt {font-size:120%;}#yiv7219158047
#yiv7219158047ygrp-vital ul li:last-child {border-right:none
!important;}#yiv7219158047
