Arrays in PL/PGSQL

Поиск
Список
Период
Сортировка
От oberpwd@anubis.network.com (Wade D. Oberpriller)
Тема Arrays in PL/PGSQL
Дата
Msg-id 200010181439.JAA25127@truck.network.com
обсуждение исходный текст
Ответы Re: Arrays in PL/PGSQL
Список pgsql-general
Hello,

Does PL/PGSQL support arrays? Or is their a mechanism to select a set of
records from a table and iterate over all of them.

For example:

DECLARE recs AS RECORDS; //??
BEGIN
SELECT INTO recs * FROM mytable WHERE myfield = 'myvalue';
for i in 1 .. NumRecs loop
    ...
end loop;

Is there a way to do something like this??

Wade Oberpriller


В списке pgsql-general по дате отправления: