Re: [GENERAL] parse error in function

2004-01-15 Thread Richard Huxton
On Thursday 15 January 2004 15:22, Uros wrote: > > 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 va

Re: [GENERAL] parse error in function

2004-01-15 Thread Tom Lane
Uros <[EMAIL PROTECTED]> writes: > I have problem with my function and I can find what's wrong. Don't use plpgsql variable names that conflict with field names of the tables you are trying to access in the function. regards, tom lane ---(end of bro

Re: [GENERAL] parse error in function

2004-01-15 Thread Uros
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: l