Re: accessing fully qualified fields in records in PLPGSQL?

dev=> CREATE FUNCTION test() RETURNS INTEGER AS '
dev'> DECLARE
dev'>   rec RECORD;
dev'>   val INTEGER;
dev'> BEGIN
dev'>   FOR rec IN SELECT oid FROM inv_locations LOOP
dev'>      val := rec.oid;
dev'>   END LOOP;
dev'> RETURN val;
dev'> END;' LANGUAGE 'plpgsql';
CREATE
dev=> select test();
  test
--------
 534321
(1 row)

Did not see your declare etc but this one works. Returns the final oid for
that table

HTH

Darren Ferguson

On Mon, 25 Mar 2002, Oberpriller, Wade D. wrote:

> How does one access a field in a record from a query like so:
>
> FOR REC IN SELECT myTable.oid FROM myTable, yourTable WHERE (myTable.id =
> yourTable.id) LOOP
>     VAL := REC.oid;
>     VAL := REC.myTable.oid;
> END LOOP;
>
> I get errors in PLPGSQL compilation for both the assignment statements
> above. What is the correct way to get the myTable oid in the REC record?
>
> Wade Oberpriller                 http://www.storagetek.com
> Software Development             Phone: (763) 424-1538
> StorageTek: MRDC                        (800) 328-9108 ext. 1538
> wade_oberpriller@storagetek.com  Fax:   (763) 391-1095
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>