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

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

From: Bruce Momjian <bruce(at)momjian(dot)us>
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 14:47:17
Message-ID: 200804091447.m39ElH301619@momjian.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Mikael Omma wrote:
> 
> The following bug has been logged online:
> 
> Bug reference:      4091
> Logged by:          Mikael Omma
> Email address:      mikael(dot)omma(at)ge(dot)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.

No, we certainly don't require the SELECT target list to match the
column definition order.  You must be doing something else wrong, but we
can't tell because you didn't show us enough details.  Try what you want
in psql and you will see it works.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-bugs by date

Next:From: Michael MeskesDate: 2008-04-09 16:08:37
Subject: Re: BUG #4091: ECPG $select incompability with Informix
Previous:From: Tom LaneDate: 2008-04-08 14:20:19
Subject: Re: BUG #4100: GMT offsets are wrong

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