Skip site navigation (1) Skip section navigation (2)

Re: pl/pgsql recursion/arrays (fwd)

From: Bo Lorentsen <bl(at)netgroup(dot)dk>
To: Jason Tan <jason(at)rebel(dot)rebel(dot)net(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: pl/pgsql recursion/arrays (fwd)
Date: 2001-09-04 08:00:43
Message-ID: 3B948A2B.A733E364@netgroup.dk (view raw or flat)
Thread:
Lists: pgsql-novice
Jason Tan wrote:

> Is it possible to use recursion in pl/pgsql in particular with postgres
> 7.0xx?

I hope I can tell you within a few days, as I need this too :-)

> Also is it posible to declare and use array in plpgsql?

Yeps, "SETOF" is your friend.

> Is it possible to somehow return a series of values?

Yeps try "RETURNS SETOF INTEGER" to define an area of integers as a return
value from a function.

> eg to return muliple values somehow so that they can be used in somethign
> like:
> select column_name from table_name where attribute_name in (select
> my_func(column2) from table2);
>
> ie so you can effectively use a function as a filter?

Yeps, this works perfectly, like this :

    SELECT a, b FROM c WHERE a.id IN (SELECT fn_return_setof());

/BL


In response to

Responses

pgsql-novice by date

Next:From: Bo LorentsenDate: 2001-09-04 08:14:46
Subject: Re: Insert rule and seqences
Previous:From: Jason TanDate: 2001-09-04 04:50:45
Subject: Re: Perl DBI Drivers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group