am 24.05.2006, um 21:54:25 +0900 mailte Michael Glaesemann folgendes:
>
> On May 24, 2006, at 11:54 , nuno wrote:
>
> >does postgresql guarantee you that
> >the columns in the result set would be ordered
> >as specified in the query (i.e. id, firstname, lastname, dob) ?
>
> No. If you want a specific order, use the ORDER BY clause.
Moment. If he say: 'select col1, col2, col3 ...', then in the result the
column-order ist col1, col2, col3. If he want to sort the rows on col1,
then he need the ORDER BY.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===