migration: parameterized statement and cursor

From: Aleksey Onopriyenko <aleksey(dot)alt(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: migration: parameterized statement and cursor
Date: 2010-01-11 14:16:38
Message-ID: e44729221001110616h36baa3b2wb57f3c2a80f97408@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

We are trying to migrate from Informix 9.4 to PostgreSQL. As part of
migration we are porting our client application.

So we need reimplement such functionality:
1. Declare a cursor using to _parameterized_ SELECT statement. It should be
possible to specify cursor's name (and, perhaps, the statement) dynamically.
2. Open that cursor (in another C-function) passing parameters to it.
3. Fetch records from result set.
4. Close the cursor.

Steps 2-4 may be repeated if necessary.

Is it possible with ecpg or libpq?

----
Best regards,
Aleksey

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-01-11 14:48:14 Re: Table appears on listing but can't drop it
Previous Message A. Kretschmer 2010-01-11 13:44:55 Re: How to get DATE in server locale format