Re: Order of columns in a table important in a stored procedure? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Order of columns in a table important in a stored procedure?
Date
Msg-id 338.1108316985@sss.pgh.pa.us
Whole thread Raw
In response to Order of columns in a table important in a stored procedure?  (Marc SCHAEFER <alphanet-postgresql-sql@alphanet.ch>)
List pgsql-sql
Marc SCHAEFER <alphanet-postgresql-sql@alphanet.ch> writes:
> I have however noticed that if the SELECT is *NOT* in the correct order
> for the table saisies, funny errors happen (such as type constraints --
> obviously columns are mixed).
> What I do not understand is that I use AS in order to name the columns,
> I would think PostgreSQL could get the column names paired.

It doesn't do it on the basis of column names.
        regards, tom lane


pgsql-sql by date:

Previous
From: Marc SCHAEFER
Date:
Subject: Order of columns in a table important in a stored procedure?
Next
From: Theo Galanakis
Date:
Subject: XML