On Fri, Apr 04, 2008 at 12:38:22PM +0000, Mikael Omma wrote:
> ECPG "$select a, b, c into :a, :b, :c from table".
> If in the db table the order of columns (b, a, c) this will not work. I
> have ESQL code from Informix ported to PostgreSQL. In informix the order in
> columns in the select query does not have to match the real order in the
> table of the database. Workaround is to reorder all columns in the ported
> code.

I just created my own test case from this small bit of information and
it works flawlessly. Would you please care to elaborate?

Michael
--
Michael Meskes
Email: Michael at Fam-Meskes dot De, Michael at Meskes dot (De|Com|Net|Org)
ICQ: 179140304, AIM/Yahoo: michaelmeskes, Jabber: meskes@jabber.org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs