Re: plpgsql FOUND Variable - Mailing list pgsql-general

From Nigel J. Andrews
Subject Re: plpgsql FOUND Variable
Date
Msg-id Pine.LNX.4.21.0308281314020.9778-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to plpgsql FOUND Variable  (Alex <alex@meerkatsoft.com>)
Responses Arrays and Indices / Foreign Keys  (Alex <alex@meerkatsoft.com>)
List pgsql-general
On Thu, 28 Aug 2003, Alex wrote:

> 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....

Works for me in 7.3.x. What are you using? Are you perhaps doing something
like:
    select count(*) from mytable

which will of course find something even if there are no rows in the
table.


--
Nigel Andrews



pgsql-general by date:

Previous
From: "Colin Mangiagalli"
Date:
Subject: Database Replication
Next
From: Bo Lorentsen
Date:
Subject: Re: mysql's last_insert_id