Thread: About functions

About functions

From
"Diego Schvartzman"
Date:
Hello all!

Is it possible to return a row or a set of rows from a user defined funcion?
Can I use user defined functions as "stored procedures"?
What I'm looking for is something that with 2 parameters (a pattern and a
table name) retrives me those rows of that table that matches a pattern.

I'm very new to pgsql and english is my second language!
Thanks in advance!!

Diego Schvartzman
ICQ# 1779434


Re: [GENERAL] About functions

From
Peter Eisentraut
Date:
On 2000-02-23, Diego Schvartzman mentioned:

> Is it possible to return a row or a set of rows from a user defined funcion?
> Can I use user defined functions as "stored procedures"?

No. Several workarounds, such as using arrays or views are known, but none
really suffice.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden