Re: MOVE in SQL vs PLPGSQL - Mailing list pgsql-sql

From Richard Huxton
Subject Re: MOVE in SQL vs PLPGSQL
Date
Msg-id 43438C5F.9070502@archonet.com
Whole thread Raw
In response to MOVE in SQL vs PLPGSQL  (andrew@pillette.com)
List pgsql-sql
andrew@pillette.com wrote:
> I can't find a good way to skip over a large number of records in
> PLPGSQL (I want to fast-forward and I don't need the I/O of reading
> and throwing away hundreds of records.) In SQL, I could just use
> MOVE. That doesn't appear to be supported in PLPGSQL?! Help?

Andrew - your question doesn't seem to make sense - can you give some 
more details? Are you having some problem with cursors in plpgsql?

--  Richard Huxton  Archonet Ltd


pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: regular expression
Next
From: Richard Huxton
Date:
Subject: Re: creating postgres tables by passing a string to function