From: Josh Berkus <josh@agliodbs.com>
To: Rison, Stuart <srison@rvc.ac.uk>
To: 'pgsql-general@postgresql.org' <pgsql-general@postgresql.org>
To: 'pgsql-sql@postgresql.org' <pgsql-sql@postgresql.org>
Subject: Re: [SQL] Copying a rowtype variable.
Date: Tue, 05 Nov 2002 08:55:27 -0800
Message-ID: <web-1813013@davinci.ethosmedia.com> (raw)
In-Reply-To: <6BD8CE460CC6EE40B83DDFCED609F84B964D33@cmnt4008.rvc.ac.uk>
Stuart,
> Just doing a bit of PL/PGSQL so my first question is:
>
> 1) should PL/PGSQL questions be posted to the general mailing list,
> the sql
> mailing list or both?
The SQL list is the best place.
> 2) I am looking for an elegant way of copying a rowtype variable:
>
> eg.
>
> DECLARE
> current_row orf%ROWTYPE;
> previous_row orf%ROWTYPE;
> BEGIN
>
> LOOP
> -- use cursors or FOR SELECT to get values into current_row
> -- now try this:
>
> previous_row = current_row;
> END LOOP;
> END;
>
> Now, as I anticipated, this fails because a rowtype variable is a
> composite
> variable. One working alternative is to do:
I haven't tried this. One thing I notice above is that you're using
the equality operator "=" instead of the assignment operator ":=" .
Usually Postgres lets you slack on this, but it would be worth trying
to see whether that has an effect on the problem.
Another thing to try is, instead of a simple variable assignment,
SELECT current_row INTO previous_row;
... and see if that works. I'll tinker later today; there has to be a
way to do it.
-Josh Berkus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, srison@rvc.ac.uk, pgsql-general@postgresql.org
Subject: Re: [SQL] Copying a rowtype variable.
In-Reply-To: <web-1813013@davinci.ethosmedia.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox