Re: [SQL] Copying a rowtype variable.

'Josh Berkus ' > Subject: Re: [SQL] Copying a rowtype variable. > > I would personnaly like this feature (assigning a composite from another > similar composite) to be added to PLPGSQL. Another nice feature would be > to able to insert a composite into a table without have to name

Re: [SQL] Copying a rowtype variable.

I would personnaly like this feature (assigning a composite from another similar composite) to be added to PLPGSQL. Another nice feature would be to able to insert a composite into a table without have to name all atributes. Just my $.02 "Rison, Stuart" wrote: > > >> 2) I am looking for an eleg

Re: [SQL] Copying a rowtype variable.

>> 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; >>

Re: [SQL] Copying a rowtype variable.

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 >

[SQL] Copying a rowtype variable.

Hello, 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? My second question is: 2) I am looking for an elegant way of copying a rowtype variable: eg. DECLARE current_row orf%ROWTYPE;