accessing fully qualified fields in records in PLPGSQL?
От
Oberpriller, Wade D.
Тема
accessing fully qualified fields in records in PLPGSQL?
Дата
Msg-id
5B7014A44B89494E830AD32859FBC85802B3857D@nsc-msg01.network.com
Список
Дерево обсуждения
accessing fully qualified fields in records in PLPGSQL? "Oberpriller, Wade D." <oberpwd@nsc-msg01.network.com>
Re: accessing fully qualified fields in records in PLPGSQL? Jan Wieck <janwieck@yahoo.com>
Re: accessing fully qualified fields in records in PLPGSQL? Darren Ferguson <darren@crystalballinc.com>
pg_dump-ing tables and their sequences Michael Adler <adler@glimpser.org>
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
В списке pgsql-general по дате отправления
От: Darren Ferguson
Дата:
От: Darren Ferguson
Дата: