Re: OID with %ROWTYPE in PLPGSQL

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