Received: from local.virton (unknown [212.9.233.138]) by postgresql.org (Postfix) with ESMTP id ABBCE475AD8; Mon, 29 Jul 2002 09:43:20 -0400 (EDT) Received: from MaxRomanov ([192.168.1.18]) by local.virton (8.11.6/8.11.6) with SMTP id g6TDNKx12284; Mon, 29 Jul 2002 16:23:20 +0300 Message-ID: <001401c23706$8cfc6d80$1201a8c0@virton.local> From: "MaksimRomanov" To: , Subject: How to get binary data from pgsql function Date: Mon, 29 Jul 2002 16:47:59 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0011_01C2371F.B22E0730" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200208/12 X-Sequence-Number: 2974 This is a multi-part message in MIME format. ------=_NextPart_000_0011_01C2371F.B22E0730 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: quoted-printable Hi=20 I want to return miltiplie row data from stored procedure in binary for= mat; 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 state= ment with plpgsql function; Is there any deccision? Thanks. ------=_NextPart_000_0011_01C2371F.B22E0730 Content-Type: text/html; charset="koi8-r" Content-Transfer-Encoding: quoted-printable

I want to return miltip= lie=20 row data from stored procedure in binary format; I use "libpq++"=20 DLL for access to PostgreSql and I want to take binary data from point= er=20 returned by PgDatabase::GetData(int,int).

I have found only one w= ay to=20 receive binary data from backend - to use "DECLARE BINARY CURSOR"=20 statement - but I don't know way to use this statement with = plpgsql=20 function;

Is there any deccision?

Thanks.

------=_NextPart_000_0011_01C2371F.B22E0730--