| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: column order |
| Date: | 2006-05-24 13:36:28 |
| Message-ID: | 20060524133628.GG11775@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Florian G. Pflug | 2006-05-24 13:36:47 | Re: column order |
| Previous Message | John D. Burger | 2006-05-24 13:30:25 | Re: challenging constraint situation - how do I make it real in SQL? |