migration: parameterized statement and cursor - Mailing list pgsql-general

From Aleksey Onopriyenko
Subject migration: parameterized statement and cursor
Date
Msg-id e44729221001110616h36baa3b2wb57f3c2a80f97408@mail.gmail.com
Whole thread Raw
Responses Re: migration: parameterized statement and cursor  (Andy Colson <andy@squeakycode.net>)
Re: migration: parameterized statement and cursor  (Pavel Stehule <pavel.stehule@gmail.com>)
List 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

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: How to get DATE in server locale format
Next
From: Adrian Klaver
Date:
Subject: Re: Table appears on listing but can't drop it