Re: problem with RECORD in a stored procedure

Поиск
Список
Период
Сортировка
От daq
Тема Re: problem with RECORD in a stored procedure
Дата
Msg-id 1746949476.20020308185315@ugyvitelszolgaltato.hu
обсуждение исходный текст
Ответ на problem with RECORD in a stored procedure  (Dalton Shane <se401029@cs.may.ie>)
Список pgsql-sql
B is record type and you can't insert a record into a field.
You must rewrite your code like this:

FOR b IN SELECT MIN(total) as mintotal from results LOOP               INSERT INTO orla(total) VALUES(b.mintotal);
END LOOP;

DAQ




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