Dunno, if it was a documented behavior it should fail both on on 8.1 Linux
and on 8.4 Windows, but it only fails on 8.4 Windows.
I will try to create a clear test.
Merlin Moncure-2 wrote:
>
> On Sun, Oct 11, 2009 at 6:21 PM, SunWuKung wrote:
>>
>> Yep,
>> it is probably a bug though.
>
> I
On Sun, Oct 11, 2009 at 6:21 PM, SunWuKung wrote:
>
> Yep,
> it is probably a bug though.
It's not...it's just the way plpgsql works. I prefix all my local
variables in plpgsql with an underscore to prevent these kinds of
conflicts.
merlin
--
Sent via pgsql-general mailing list (pgsql-general
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
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 point
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
SunWuKung wrote:
>
>
> Y
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 ha
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
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.
