Re: BUG #4091: ECPG $select incompability with Informix

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(at)jabber(dot)org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!