Re: [SQL] FUNCTIONS PROBLEM

[David Witham]

Hi Mario,

I have used a record type to do this:

create myfunc() returns record as '

declare
        return_val      record;
        col1            int;
        col2            int;
        col3            real;
        col4            char;

        col1 := 5;
        col2 := 10;
        col3 := 2.7;
        col4 := ''z'';

        select col1,col2,col3,col4 into return_val;
        return return_val;
end;
' language 'plpgsql';

When you call the function you need to specify the expected output:

select * from myfunc() as (val1 int, val2 int, val3 real, val4 char);

See the SELECT reference page in the documentation.

There are other ways (which may be better) to do this that don't require the output 
types to be specified with the query but this is the one I got going first so I stuck 
with it. Hope this helps.

Regards,
David Witham
Telephony Platforms Architect
Unidial

-----Original Message-----
From: Mario Alberto Soto Cordones [mailto:[EMAIL PROTECTED]
Sent: Friday, 21 March 2003 09:26
To: [EMAIL PROTECTED]
Subject: [SQL] FUNCTIONS PROBLEM
Importance: High


Hi.

i have a function and i need to return 4 fields but not work,

any idea , please

thank

mario



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])