Hi folks,
I want to scroll through the results of the same query inside a PL/pgSQL
function several times and learned that cursors can help me doing that.
However, the command "MOVE FIRST FROM " is not accepted by
the parser. Likewise, I get a similar error message when using the FETCH
command
Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
>
>>I believe it sees the one that was valid in the snapshot as of the
>>beginning of the function.
>
>
> Actually, the problem is that it can see *both* that row and the updated
> row; it's a crapshoot which one will be returned by the SE
On Thu, 2004-08-26 at 04:23, Gaetano Mendola wrote:
> Tom Lane wrote:
>
> > Stephan Szabo <[EMAIL PROTECTED]> writes:
> >
> >>I believe it sees the one that was valid in the snapshot as of the
> >>beginning of the function.
> >
> >
> > Actually, the problem is that it can see *both* that ro
Robert Treat wrote:
On Thu, 2004-08-26 at 04:23, Gaetano Mendola wrote:
Tom Lane wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
>
>>I believe it sees the one that was valid in the snapshot as of the
>>beginning of the function.
>
>
> Actually, the problem is that it can see *both* that row and
"Spencer Quin" <[EMAIL PROTECTED]> writes:
> Tom, I am not sure if my original message made it onto a forum or
> knowledge base but I was wondering if it would be possible for you to
> take it down if it is? There may potentially be some sensitive
> information in it.
The bugs list is archived, y
