Re: Obtaining random rows from a result set - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Obtaining random rows from a result set
Date
Msg-id 46DD7D74.1050806@magproductions.nl
Whole thread Raw
In response to Re: Obtaining random rows from a result set  (Alban Hertroys <alban@magproductions.nl>)
List pgsql-general
Alban Hertroys wrote:
> To follow up on my own post, I came up with a workable solution based on
> scrolling cursors. The SP approach didn't work out for me, I didn't
> manage to declare a cursor in PL/pgSQL that could be positioned
> absolutely (maybe that's due to us still using PG 8.1.something?).

Doh! I mean I couldn't use MOVE FORWARD ALL IN _cur for some reason, it
kept saying "Syntax error".

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Obtaining random rows from a result set
Next
From: Madison Kelly
Date:
Subject: SELECT question (splitting a field)