Re: column order

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: "nuno" <wegein(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: column order
Date: 2006-05-24 12:54:25
Message-ID: C153126D-863B-4E36-BD8B-F2F977977D4C@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Volkan YAZICI 2006-05-24 13:23:22 Re: meaning of PQresultStatus types
Previous Message Kenneth Downs 2006-05-24 12:38:29 Re: background triggers?