By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

weird issues with plpgsql calls.

P: n/a
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)

Nov 23 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.