Re: Select, but returning binary data.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "M(dot) Bastin" <marcbastin(at)mindspring(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Select, but returning binary data.
Date: 2003-05-08 14:28:22
Message-ID: 20098.1052404102@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"M. Bastin" <marcbastin(at)mindspring(dot)com> writes:
> I can't figure out how to issue a select statement that will return
> binary data instead of textual data. (pgSQL backend message "B"
> instead of "D".)

You can't; the only operation that produces B messages is a FETCH
from a binary cursor.

This will be improved on in 7.4, btw.

> I'm also having some trouble finding documentation about "function
> calls", and what their use is.

Very little --- I'd call the feature obsolete myself. You might
as well just do "SELECT foo(...)".

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Pam Wampler 2003-05-08 15:22:39 upgrade tips
Previous Message sureshk2003 2003-05-08 14:00:18