cursors Vs for loops in pl/pgsql - Mailing list pgsql-general

From Tim McAuley
Subject cursors Vs for loops in pl/pgsql
Date
Msg-id 000a01c285a5$8df42140$6802a8c0@MOTHY
Whole thread Raw
List pgsql-general
Hi,

We've recently upgraded our Postgresql from 7.1.3 to 7.2.1.

We use for loops in our stored procedures (due to the fact that cursors were
not present in pl/pgsql until now). I'm just wondering if this is the way to
continue or should we look at using cursors instead? Is there any
performance difference between the two (considering that for loops use
cursors internally anyway).

Thanks,

Tim



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: CURRENT_TIME
Next
From: Bruce Momjian
Date:
Subject: Re: Formatting psql output