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 [EMAIL PROTECTED])