On Thursday 15 January 2004 14:25, Uros wrote:
> Hello!
>
> I have problem with my function and I can find what's wrong.
>
> WARNING: Error occurred while executing PL/pgSQL function
> fn_insert_entry_pending WARNING: line 26 at SQL statement
> ERROR: parser: parse error at or near "$1" at character 58
Possibly unrelated, but what is this variable?
> SELECT INTO tmp id_user FROM "user" WHERE id_user = email;
^^^
Also - make sure you haven't got a column called 'email' in any query where
you are using the variable 'email' - that can cause confusion.
--
Richard Huxton
Archonet Ltd