assign count() result to a declared variable in plpgsql

Поиск
Список
Период
Сортировка
От Joseph Syjuco
Тема assign count() result to a declared variable in plpgsql
Дата
Msg-id 1024932336.15861.8.camel@Askr
обсуждение исходный текст
Ответы Re: assign count() result to a declared variable in plpgsql
Re: assign count() result to a declared variable in plpgsql
Список pgsql-sql
i want to put my count() result in a plpgsql declared integer variable


declare f_count_var integer;
beginselect into f_count_var count(empno) from employee
end;

tried this one but it doesnt work











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