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
