Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: column order
- From: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: column order
- Date: Wed, 24 May 2006 15:36:28 +0200
- Message-id: <20060524133628(dot)GG11775(at)webserv(dot)wug-glas(dot)de>
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 ===
- References:
- column order
- From: nuno
- Re: column order
- From: Michael Glaesemann
- column order
- Prev by Date: Re: challenging constraint situation - how do I make it real in SQL?
- Next by Date: Re: column order
- Previous by thread: Re: column order
- Next by thread: Re: column order
- Indexes: