insert rowtype - Mailing list pgsql-sql

From Bryan Klimt
Subject insert rowtype
Date
Msg-id 22B5FF60-815D-11D7-B60D-000A95774E48@baylor.edu
Whole thread Raw
Responses Re: insert rowtype  (Bryan Klimt <Bryan_Klimt@baylor.edu>)
List pgsql-sql
In a plpgsql function, I have a variable of type table%rowtype
I populate the row by calling "select into <variable> * from <table>"
then i change some stuff like "<variable>.<field> := <new value>"
now i want to insert the row into the table as a new row - is there an 
easy way to do this?

i know i could do "insert into <table> values ( <variable>.<field 1>, 
<variable>.<field 2>, ... );"
but that is a lot of typing, and it seems like there should be an 
easier way.

-Bryan



pgsql-sql by date:

Previous
From: "SZŰCS Gábor"
Date:
Subject: Re: "too clever" when creating SQL functions
Next
From: Tom Lane
Date:
Subject: Re: seeing type defination..