How to get binary data from pgsql function

From: "MaksimRomanov" <MaksimRomanov(at)mail(dot)ru>
To: <pgsql-interfaces(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: How to get binary data from pgsql function
Date: 2002-07-29 13:47:59
Message-ID: 001401c23706$8cfc6d80$1201a8c0@virton.local
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

Hi

I want to return miltiplie row data from stored procedure in binary format; I use "libpq++" DLL for access to PostgreSql and I want to take binary data from pointer returned by PgDatabase::GetData(int,int).
I have found only one way to receive binary data from backend - to use "DECLARE BINARY CURSOR" statement - but I don't know way to use this statement with plpgsql function;
Is there any deccision?

Thanks.

Browse pgsql-interfaces by date

  From Date Subject
Next Message William West 2002-07-29 14:06:16 Still "Stalled"? ECPG - varchar in struct?
Previous Message Denis Chavez 2002-07-28 04:04:53 Kerberos authentication with libpgtcl

Browse pgsql-sql by date

  From Date Subject
Next Message Milosz Krajewski 2002-07-29 14:50:29 How to optimize SQL query ?
Previous Message Elielson Fontanezi 2002-07-29 11:57:12 RES: [SQL] RES: set DateStyle to 'SQL'