Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: column order

  • From: "Florian G. Pflug" <fgp(at)phlo(dot)org>
  • To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
  • Cc: nuno <wegein(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
  • Subject: Re: column order
  • Date: Wed, 24 May 2006 15:36:47 +0200
  • Message-id: <4474616F(dot)2010406(at)phlo(dot)org>
Michael Glaesemann wrote:


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.

I think the OP was talking about the order by the _columns_, not
the _rows_.

Postgres guarantees that order - Anything else would be simply insane.

greetings, Florian Pflug
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group