From: Josh Berkus <josh@agliodbs.com>
Reply-To: josh@agliodbs.com
Organization: Aglio Database Solutions
To: pgsql-sql@postgresql.org
Subject: Re: Using descriptor areas to insert
Date: Thu, 22 Sep 2005 15:10:23 -0700
User-Agent: KMail/1.8
Cc: andy rost <andy.rost@noaa.gov>
References: <4332D278.9@noaa.gov>
In-Reply-To: <4332D278.9@noaa.gov>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200509221510.23942.josh@agliodbs.com>

Andrew,

> I'm in the final stages of porting a large body of ESQL software from
> Informix to PostgreSQL (V8). The last few Informix-based functions
> involve Informix descriptor areas to insert rows into a table. I've
> sorted out the logic for using PostgreSQL descriptor areas for select
> statements. How do you go about using the PostgreSQL descriptor areas
> for insert statements? Is there another way to approach the problem of
> insert records into an arbitrary table using dynamic SQL?

Hmmm, I don't quite follow you, mostly because I'm *not* an Informix 
person.  Could you give an example?

Also, if you still have contact, Dave Cramer or Elein should be able to 
answer this question ...

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco