Home > mailing lists

Re: plpgsql: help with RECORD type - Mailing list pgsql-novice

From	Semyon Chaichenets
Subject	Re: plpgsql: help with RECORD type
Date	March 3, 2009 20:51:31
Msg-id	6f81e0890903031351m7eb6c3deu6159dc78fdbee8d8@mail.gmail.com Whole thread Raw
In response to	Re: plpgsql: help with RECORD type (Vyacheslav Kalinin <vka@mgcp.com>)
List	pgsql-novice

Vyacheslav,

thank you so much!

Semyon Chaichenets

On Tue, Mar 3, 2009 at 16:19, Vyacheslav Kalinin <vka@mgcp.com> wrote:

There is no set variables in plpgsql. If you want to retrieve set of rows for futher manipulation either use a CURSOR or ARRAY:

[...]

I believe what you want to achieve can be done with simple query result looping:

[..]

From: Vyacheslav Kalinin
Date: 03 March 2009, 20:26:22
Subject: Re: plpgsql: help with RECORD type

From: "Rosenblum, Jason"
Date: 06 March 2009, 12:40:22
Subject: Prepared Statement