From: Tom Lane <tgl@sss.pgh.pa.us>
To: Marc SCHAEFER <alphanet-postgresql-sql@alphanet.ch>
Cc: pgsql-sql@postgresql.org
Subject: Re: Order of columns in a table important in a stored procedure?
Date: Sun, 13 Feb 2005 12:49:45 -0500
Message-ID: <338.1108316985@sss.pgh.pa.us> (raw)
In-Reply-To: <20050213170347.GA2658@defian.alphanet.ch>
References: <20050213170347.GA2658@defian.alphanet.ch>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, alphanet-postgresql-sql@alphanet.ch
Subject: Re: Order of columns in a table important in a stored procedure?
In-Reply-To: <338.1108316985@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox