column order

From: "nuno" <wegein(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: column order
Date: 2006-05-24 02:54:58
Message-ID: 1148439298.596562.164450@y43g2000cwc.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi, all.

i have a couple of questions regarding the order of table columns.

say, you have a following query;
SELECT id, firstname, lastname, dob FROM student;

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) ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-05-24 03:08:58 Re: [SQL] (Ab)Using schemas and inheritance
Previous Message Jorge Godoy 2006-05-24 02:20:04 What to expect when mixing inherited tables and different schemas while dealing with functions and views?