470,614 Members | 1,434 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

plpgsql FOUND Variable

Hi,
when I run a SELECT INTO and the result is 0 or zero row, then I still
get a positive result if
using IF FOUND THEN....

Is there a problem or do we need to use ROW_COUNT instead ?

Alex

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 11 '05 #1
1 3513
Alex <al**@meerkatsoft.com> writes:
when I run a SELECT INTO and the result is 0 or zero row, then I still
get a positive result if
using IF FOUND THEN....


I recall Neil Conway fixed some problems with FOUND a version or two
back. If you are not on 7.3.*, update. If you are, let's see the
details.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Martin Marques | last post: by
2 posts views Thread by Darren Ferguson | last post: by
1 post views Thread by Rajesh Kumar Mallah | last post: by
10 posts views Thread by lnd | last post: by
4 posts views Thread by Bill Moran | last post: by
reply views Thread by sripathy sena | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.