Dynamically discovering field names in PLPGSQL queries

Поиск
Список
Период
Сортировка
От Oberpriller, Wade D.
Тема Dynamically discovering field names in PLPGSQL queries
Дата
Msg-id A7E1C26945C8D211ADBF0008C709661A01D4126A@nsc-msg02.network.com
обсуждение исходный текст
Ответы Re: Dynamically discovering field names in PLPGSQL queries  (Bruno Wolff III <bruno@wolff.to>)
Re: Dynamically discovering field names in PLPGSQL queries  (will trillich <will@serensoft.com>)
Список pgsql-general
Is there a way to discover the names of the fields in a record from a SELECT
statement in PLPGSQL?

For example:

SELECT INTO REC * FROM mytable;

Is there a mechanism to determine what the "*" expanded to? or does a
programmer always have to know the layout of the table apriori?

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 по дате отправления:

Предыдущее
От: Evan Zane Macosko
Дата:
Сообщение: Re: Problems with UPDATE
Следующее
От: Andrew Gould
Дата:
Сообщение: Re: System tables showing in result from '\d'