Re: parse error in function

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