Re: Order of columns in a table important in a stored procedure?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc SCHAEFER <alphanet-postgresql-sql(at)alphanet(dot)ch>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Order of columns in a table important in a stored procedure?
Date: 2005-02-13 17:49:45
Message-ID: 338.1108316985@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Marc SCHAEFER <alphanet-postgresql-sql(at)alphanet(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Gintz 2005-02-13 22:43:29 Re: Order of columns in a table important in a stored procedure?
Previous Message Marc SCHAEFER 2005-02-13 17:03:47 Order of columns in a table important in a stored procedure?