Yes, I use it as a table alias inside the function. Select .......... irq.instreq_min_metcount, irq.ref_deptype, irq.instreq_aggrfunc >From .................. instrument_requirement irq ON ........ Adrian Klaver wrote: > > On Sunday 11 October 2009 2:20:32 pm SunWuKung wrote: >> Hi, >> I have a plpgsql function called irq(IN ulist integer[], .....) >> It works fine on 8.1 Linux >> >> On 8.4 on windows XP running the function gives an error message >> (Undefined >> column: 7 ERROR: record "rec" has no field "instreq_id") wich is strange >> because the underlying query does return that column. >> I run the create script of irq to create irq2 - and irq2 works fine. >> I delete irq and rename irq2 to irq and I get the error back. >> >> The error is consistent in the sense that if I delete the database and >> restore it it appears again the same way. >> >> Is this a bug? >> Any suggestion what I should be doing with this? >> >> Thanks for the help. >> SWK >> -- >> View this message in context: >> http://www.nabble.com/strange-plpgsql-error-tp25847709p25847709.html Sent >> from the PostgreSQL - general mailing list archive at Nabble.com. > > Are you using the string 'irq' inside the function? > > -- > 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-tp25847709p25847881.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