Re: pgplsql, how to save row variable to a table row - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: pgplsql, how to save row variable to a table row
Date
Msg-id 47EA4442.8050201@iol.ie
Whole thread Raw
In response to Re: pgplsql, how to save row variable to a table row  (Sam Mason <sam@samason.me.uk>)
List pgsql-general
On 26/03/2008 12:26, Sam Mason wrote:

>   INSERT INTO f2_tempfac
>     SELECT (row_tempf).*;

Does this depend on the column order in table f2_tempfac being the same
as that in the SELECT that produced row_tempf?

Or will row_tempf.foo automagically get matched with column
f2_tempfac.foo, etc?

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
---------------------------------------------------------------

pgsql-general by date:

Previous
From: "Roberts, Jon"
Date:
Subject: Re: select any table
Next
From: Craig Ringer
Date:
Subject: Re: pgplsql, how to save row variable to a table row