Обсуждение: Using EXECUTE in plpgsql

Поиск
Список
Период
Сортировка

Using EXECUTE in plpgsql

От
Jonathon Batson
Дата:
Hi
I have just experimenting with plpgsql and cannot find out how to return
a single field from a query
that I know will only every return one field.  I currently use the
example below:

    qrystr1 := ''SELECT count(*) from my_table";
    FOR next_table IN EXECUTE qrystr1 LOOP
        next_table_count := next_table.count;
    END LOOP;

which seems like a very inadequate way to retrieve one value....?

Tips are very much aprieciated, thanks
Jonathon