pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedUsing descriptor areas to insert
2+ messages / 2 participants
[nested] [flat]
* Using descriptor areas to insert
@ 2005-09-22 15:49 andy rost <andy.rost@noaa.gov>
2005-09-22 22:10 ` Re: Using descriptor areas to insert Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 2+ messages in thread
From: andy rost @ 2005-09-22 15:49 UTC (permalink / raw)
To: pgsql-sql
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?
Thanks ...
--
--------------------------------------------------------------------------------
Andrew Rost
National Operational Hydrologic Remote Sensing Center (NOHRSC)
National Weather Service, NOAA
1735 Lake Dr. West, Chanhassen, MN 55317-8582
Voice: (952)361-6610 x 234
Fax: (952)361-6634
arost@nohrsc.nws.gov
http://www.nohrsc.nws.gov
--------------------------------------------------------------------------------
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Using descriptor areas to insert
2005-09-22 15:49 Using descriptor areas to insert andy rost <andy.rost@noaa.gov>
@ 2005-09-22 22:10 ` Josh Berkus <josh@agliodbs.com>
0 siblings, 0 replies; 2+ messages in thread
From: Josh Berkus @ 2005-09-22 22:10 UTC (permalink / raw)
To: pgsql-sql; +Cc: andy rost <andy.rost@noaa.gov>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-09-22 22:10 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-09-22 15:49 Using descriptor areas to insert andy rost <andy.rost@noaa.gov>
2005-09-22 22:10 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox