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 akla...@comcast.net -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
