BUG #3590: Error while in Plpgsql :
От | Abdus Samad Ansari |
---|---|
Тема | BUG #3590: Error while in Plpgsql : |
Дата | |
Msg-id | 200708310923.l7V9NEX2091513@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #3590: Error while in Plpgsql :
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 3590 Logged by: Abdus Samad Ansari Email address: abdus.samad.ansari@gmail.com PostgreSQL version: 7.4.2. Operating system: Fedora 2 Linux Description: Error while in Plpgsql : Details: I am using a plpgsql function and in this I am issuing a insert as : Insert into pis.hrt_emp_leave_bin (emp_no,leave_cd,curr_dt,bin_sl_no,cal_yr,tran_typ,open_bal,ytd_availed,avai led) values (EmployeeNumber, LeaveCode, CurrentDate, Bin_Serial_No,to_number(to_char(CurrentDate,''YYYY''),''9999''),''CM'', OpenBal,YtdAvailed+LeaveVal,LeaveVal); This insert statement while run give an error message : ERROR: syntax error at or near "$1" at character 35 The problem is with the column named "availed", while I renamed the column availed as "availd", the same statement works fine. I could not understand this, whether the word availed is a reserve word for plpgsql? or something else? Thanks in advance. Abdus Samad Ansari
В списке pgsql-bugs по дате отправления: