Re: OID with %ROWTYPE in PLPGSQL

I claimed victory to quickly.

PLPGSQL did compile, run and did not complain about OID but it was
always set to 0.

JLL



Jean-Luc Lachance wrote:
>
> Well, I found a solution for now.
>
> I use RECORD in stead of ROWTYPE.
> RECORD does hold OID if it exists.
>
> JLL
>
> P.S. I am still interested about updating a record in place.
>
> Jean-Luc Lachance wrote:
> >
> > Hello all,
> >
> > Is there a way to have the OID included with %ROWTYPE?
> > If not, can the record pointed to by a ROWTYPE record in a loop be
> > updated in place?
> > If not, can the record pointed by a cursor be updated in place?
> >
> > If not can we add one of those to the list of "nice to have" for the
> > next version?
> >
> > While I am at it, why not allow assignment of row variable from another
> > row variable?
> >
> > Thanks
> >
> > JLL
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)