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
Дата:
FAQ