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

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