BUG #4091: ECPG $select incompability with Informix - Mailing list pgsql-bugs

From Mikael Omma
Subject BUG #4091: ECPG $select incompability with Informix
Date
Msg-id 200804041238.m34CcMbW007189@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4091: ECPG $select incompability with Informix
Re: BUG #4091: ECPG $select incompability with Informix
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4091
Logged by:          Mikael Omma
Email address:      mikael.omma@ge.com
PostgreSQL version: 8.2.6
Operating system:   SUSE Linux 10
Description:        ECPG $select incompability with Informix
Details:

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.

pgsql-bugs by date:

Previous
From: "J6M"
Date:
Subject: Re: BUG #4096: PG 8.3.1. confused about remaining disk space
Next
From: Tom Lane
Date:
Subject: Re: BUG #4100: GMT offsets are wrong