Returning multiple rows in 8.4

Поиск
Список
Период
Сортировка
От Baris Gerze
Тема Returning multiple rows in 8.4
Дата
Msg-id 4AF89665.8090402@gmail.com
обсуждение исходный текст
Список pgsql-general
I have users table such as
 create table users(
   user_id   bigserial,
   user_name varchar(50),
   user_surname varchar(100)
 );


how can I write a function to return multiple rows? ( in plpgsql )

what is the return value of the function? records?


and how can i run it without running as select my_func() as (int8,
varchar) ???
is there simple way to do this?

thanks





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