Posted By: okbob (okbob) on 'CZdatabases'
Title:     ulozene procedury v postgresql?
Date:      Mon Nov 12 21:08:47 2001

Zdravim

Lze psat v pl/pgsql ulozene procedury vracejici tabulku, napr. ekvivalent v 
tsql by byl nasledujici:

alter procedure test
as
  create table #tt(a int, b int, c int)
  insert into #tt values(10,20,30)
  insert into #tt values(10,30,20)
  select * from tt

vysledkem exec test je tabulka 
a  | b  | c
---+----+-----
10 | 20 | 30
10 | 30 | 20

Pavel