Re: FOR from query - is it a bug ?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Szymic1 <dyrex(at)poczta(dot)onet(dot)pl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FOR from query - is it a bug ?
Date: 2006-07-06 18:50:53
Message-ID: 20060706185053.GA48836@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 06, 2006 at 07:37:17AM -0700, Szymic1 wrote:
> I have function (below) that returns values in table format. But when
> source table ( xxx.logic_list_item ) is empty I've got following
> message in log:
> "row number -1 is out of range 0..-1"

What log? What client are you using -- psql or something else?
Warnings like this can happen if a client application calls a libpq
function like PQgetvalue() without first checking whether the query
returned any tuples.

--
Michael Fuhr

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karl O. Pinc 2006-07-06 18:57:56 Long term database archival
Previous Message Scott Marlowe 2006-07-06 18:41:56 Re: Granting COPY FROM access