Re: Error Occurred when run function. How to solve it?

Hi,

--On Montag, 25. November 2002 01:17 +0800 annachau <annachau(at)hongkong(dot)com>
wrote:

> Error Occurred when run function. Please give me some advices. Thanks.
>
> The function:
> -- Function: usf_annatest(varchar, varchar)
> CREATE FUNCTION usf_annatest(varchar, varchar) RETURNS varchar AS '
> DECLARE
> curs_userdetail refcursor;
> table_name ALIAS for $1;
> identity ALIAS for $2;
> query_where VARCHAR;
>
> BEGIN
> IF table_name = "ot_customer" THEN
^^^^^^^^^^^^

(as the error tells you) You have to write ''ot_customer'' note the
double single ' instead of one double ".

Regards
Tino

> RETURN table_name;
> ELSE
> RETURN identity;
> END IF;
> END;' LANGUAGE 'plpgsql';
>
> I run it :
> SELECT usf_annatest('ot_test', 'anna');
>
> Error :
> NOTICE: Error occurred while executing PL/pgSQL function usf_annatest
> NOTICE: line 8 at if
> ERROR : Attribute 'ot_customer' not found.
>
> So, when I need to user "ot_customer" and 'ot_customer'.
>
> Thanks a lot.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)