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 === ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
