From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
---|---|
To: | Dennis Gearon <gearond(at)fireserve(dot)net> |
Subject: | Re: basics on User Defined Functions |
Date: | 2004-09-21 23:36:56 |
Message-ID: | 4150BB18.80207@bigfoot.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dennis Gearon wrote:
> Is this the correct way to return values in a record from a UDF in 7.4.+ ?
>
> Is it ok to modify the arguments as in 'arg_int'?
>
> -- return type should be RECORD
> --
> CREATE OR REPLACE FUNCTION test_function( int )
> RETURNS RECORD AS ' DECLARE
>
> arg_int ALIAS FOR $1;
>
> var_record_out record;
> var_message_out text;
>
> BEGIN
>
> var_message_out := ''This was successful'';
> arg_int := rg_int * 3;
>
> SELECT INTO var_record_out :arg_int AS intX3,
> :var_message_out AS message;
> RETURN var_record_out;
> END;
> ' LANGUAGE 'plpgsql';
Did you execute it ?
rg_int is not declared, may be is a typo for arg_int; however
you can not modify the argument function.
Is it an homework ?
Regards
Gaetano Mendola
From | Date | Subject | |
---|---|---|---|
Next Message | Dennis Gearon | 2004-09-21 23:53:19 | difference 7.3.xx vs 7.4.xx |
Previous Message | Ed L. | 2004-09-21 22:03:58 | Re: Unable to drop DB in latest CVS version |