ストアドプロシージャで複数の値を返す様にするにはユーザ定期型を用いる
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
create type your_type as ( timestamp timestamp with time zone, value1 float, value2 float ); create or replace function your_storedprocedure ( starttime timestamp with time zone, endtime timestamp with time zone ) returns your_type as $$ : |