Re: Select, but returning binary data. - Mailing list pgsql-novice

From Tom Lane
Subject Re: Select, but returning binary data.
Date
Msg-id 20098.1052404102@sss.pgh.pa.us
Whole thread Raw
In response to Select, but returning binary data.  ("M. Bastin" <marcbastin@mindspring.com>)
List pgsql-novice
"M. Bastin" <marcbastin@mindspring.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


pgsql-novice by date:

Previous
From: "sureshk2003"
Date:
Subject:
Next
From: Pam Wampler
Date:
Subject: upgrade tips