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(at)storagetek(dot)com Fax: (763) 391-1095