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(at)comcast(dot)net