Yep, it is probably a bug though. Adrian Klaver wrote: > > On Sunday 11 October 2009 2:48:02 pm SunWuKung wrote: >> Right, >> I replace the table alias irq to instreq and the function works. >> I don't know what could have been the problem: is irq a reserved word, or >> it's because the table alias has the same name then the function name. >> >> Thanks for pointing me to the right direction. >> SWK >> > > It is not a reserved word > (http://www.postgresql.org/docs/8.4/interactive/sql-keywords-appendix.html). > My guess is it was the name conflict between the function name and the > table > alias. > > > -- > Adrian Klaver > aklaver@xxxxxxxxxxx > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://www.nabble.com/strange-plpgsql-error-tp25847709p25848214.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general