weird issues with plpgsql calls.

[Jeff MacDonald]

Hi,

I've made up 2 plpgsql calls, the table and function schema is available at

http://www.bignose.ca/help/pg.txt

I call them like this

select ad_hits(33760);
select ad_inquiries(33760);

i did an "update ad_base set hits = 0, inquiries = 0" to initialize both rows,
since i added them using alter table.

if i call ad_inquiries a few times, the number increments just fine,
but if i call
ad_hits, it increments hits like it should, but also sets inquiries to
zero. which
is very strange and annoying ;)

any help would be great, thanks !

PostgreSQL 7.3.4 on i386-unknown-freebsd5.1, compiled by GCC gcc (GCC)
3.2.2 [FreeBSD] 20030205 (release)

--
Jeff MacDonald
http://www.bignose.ca

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)