anter
05-30-2010, 04:12 PM
When I try to run the query below in pgAdmin III I get an out of memory message.
SELECT standardizedhandhistory
FROM handhistories
JOIN pokerhands
ON pokerhands.pokerhand_id = handhistories.pokerhand_id
JOIN pokersites
ON pokersites.site_id = pokerhands.site_id
WHERE sitename = 'Prima'
I've understood from a little reading that I can use something called a "cursor" to fix the out of memory problem.
Do you know how/if a cursor can be used to make the above query work?
SELECT standardizedhandhistory
FROM handhistories
JOIN pokerhands
ON pokerhands.pokerhand_id = handhistories.pokerhand_id
JOIN pokersites
ON pokersites.site_id = pokerhands.site_id
WHERE sitename = 'Prima'
I've understood from a little reading that I can use something called a "cursor" to fix the out of memory problem.
Do you know how/if a cursor can be used to make the above query work?