Skip site navigation (1) Skip section navigation (2)

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

From: Michael Meskes <meskes(at)postgresql(dot)org>
To: Mikael Omma <mikael(dot)omma(at)ge(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4091: ECPG $select incompability with Informix
Date: 2008-04-09 16:08:37
Message-ID: 20080409160837.GA11869@feivel.credativ.de (view raw or flat)
Thread:
Lists: pgsql-bugs
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!

In response to

pgsql-bugs by date

Next:From: Prakash SuryawanshiDate: 2008-04-10 09:59:16
Subject: Error in module
Previous:From: Bruce MomjianDate: 2008-04-09 14:47:17
Subject: Re: BUG #4091: ECPG $select incompability with Informix

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group