Benoît Minisini a écrit :
...
>
> You can access result fields by index too:
>
> resQry[0], reqQry[1], ...
Haaa this sounds very good too :)
--
Bringing your mate to a convention is like taking a game warden hunting.
> Hi,
>
> How can I retrieve a "field" returned by a stored procedure?
>
> SP:
> CREATE OR REPLACE FUNCTION common.testbytea_sel(Pid OID) RETURNS TEXT AS $$
> DECLARE
> MyPic BYTEA;
> MyStringTEXT;
> BEGIN
> SELECT pic INTO MyPic FROM common.testbytea WHE
dim hField as ResultField
For each hField in resQry.Fields
Print hField.Name
Next
2009/11/26 Jean-Yves F. Barbier <12u...@gmail.com>:
> Hi,
>
> How can I retrieve a "field" returned by a stored procedure?
>
> SP:
> CREATE OR REPLACE FUNCTION common.testbytea_sel(Pid OID) RETURNS TEXT AS
Hi,
How can I retrieve a "field" returned by a stored procedure?
SP:
CREATE OR REPLACE FUNCTION common.testbytea_sel(Pid OID) RETURNS TEXT AS $$
DECLARE
MyPic BYTEA;
MyStringTEXT;
BEGIN
SELECT pic INTO MyPic FROM common.testbytea WHERE id = Pid;