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

On Wed, Mar 26, 2008 at 01:14:07PM +0100, josep porres wrote:
> I've tried:
>
> EXECUTE 'INSERT INTO F2_TEMPFAC SELECT * FROM row_tempf';

I think that:

  INSERT INTO f2_tempfac
    SELECT (row_tempf).*;

should do what you want.  Unless you're doing something very fancy you
don't want the execute either.  You can just put normal SQL statements
in the code and they'll get run as normal, expanding variables when
needed.


  Sam