| Subject | Re: [firebird-support] Re: order by column index |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-09-01T11:43:30Z |
At 11:28 AM 1/09/2003 +0000, you wrote:
"index" but "position". If this word isn't techie enough for you, then you
can use the word "degree". :-)
Any set in a RDBMS has 1 or more columns. This includes the output set
that you define in the SELECT list. Across a row, each column has a
degree, which is its left-to-right position in the row, starting at 1.
An "index" in an RDBMS is quite a different thing. Quite useful for
ordering by, though. :-))
heLen
>SorryYou made your post double confusing. The word you are looking for is not
>
>I typed in the word COLUMN incorrectly. It shouldn't have been in my
>first post.
>
> >From what I can see Firebird doesn't seem to have a problem with the
>column index being used in the order by clause.
"index" but "position". If this word isn't techie enough for you, then you
can use the word "degree". :-)
Any set in a RDBMS has 1 or more columns. This includes the output set
that you define in the SELECT list. Across a row, each column has a
degree, which is its left-to-right position in the row, starting at 1.
An "index" in an RDBMS is quite a different thing. Quite useful for
ordering by, though. :-))
heLen