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

Поиск
Список
Период
Сортировка
От Michael Meskes
Тема Re: BUG #4091: ECPG $select incompability with Informix
Дата
Msg-id 20080409160837.GA11869@feivel.credativ.de
обсуждение исходный текст
Ответ на BUG #4091: ECPG $select incompability with Informix  ("Mikael Omma" <mikael.omma@ge.com>)
Список 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@jabber.org
Go VfL Borussia! Go SF 49ers! Use Debian GNU/Linux! Use PostgreSQL!

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #4091: ECPG $select incompability with Informix
Следующее
От: "J6M"
Дата:
Сообщение: Re: BUG #4096: PG 8.3.1. confused about remaining disk space