Re: declare variable in udf

[Peter Kroon <plakroon@xxxxxxxxx>]

So, multiple DECLARE sections are not allowed?

2012/11/21 Raymond O'Donnell <rod@xxxxxx>

On 21/11/2012 11:42, Peter Kroon wrote:
> Hello,
>
> How do I declare a variable after BEGIN?
> I want to declare it in the if statement.
>
> DROP FUNCTION IF EXISTS tmp_test(integer);
> CREATE FUNCTION tmp_test(
> p_id integer
> )
> RETURNS text
> AS $$
> DECLARE the_return_value text;
> BEGIN
> DROP TABLE IF EXISTS temp_test_table;
> CREATE TEMP TABLE temp_test_table(
> some_value text
> );
> INSERT INTO temp_test_table
> SELECT data FROM table WHERE id=p_id;
> SELECT INTO the_return_value some_value FROM temp_test_table;
>
> IF 1=1 THEN
>                 --how do I declare a variable here? it this possible?
> RAISE NOTICE 'this is a notice';
> END IF;
>
> RETURN the_return_value;
>
> END;
> $$ language plpgsql

I don't think that is possible - you have to declare all your variables
in the DECLARE section.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@xxxxxx