Re: parse error in function

Hello Richard,

Thursday, January 15, 2004, 4:10:10 PM, you wrote:

RH> 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

RH> Possibly unrelated, but what is this variable?

>> SELECT INTO tmp id_user FROM "user" WHERE id_user = email;
RH> ^^^

RH> Also - make sure you haven't got a column called 'email' in any query where
RH> you are using the variable 'email' - that can cause confusion.

Problem was aliases, becasu alias name was the same as column and then the
same name was value and rowname. I replace all names like email1 etc. and
it works. I hope ;).

--
Best regards,
Uros mailto:uros(at)sir-mag(dot)com