pl/pgsql recursion/arrays (fwd)

From: Jason Tan <jason(at)rebel(dot)rebel(dot)net(dot)au>
To: pgsql-novice(at)postgresql(dot)org
Subject: pl/pgsql recursion/arrays (fwd)
Date: 2001-08-30 09:18:10
Message-ID: Pine.LNX.3.95.1010830184753.9410D-100000@rebel.rebel.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Hi all,

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

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

Is it possible to somehow return a series of values?

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?

Regards and Thanks in advance,
Jason

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message CONDLEJ 2001-08-30 13:42:46 Installation Problem on Solaris
Previous Message Vijay Deval 2001-08-30 03:28:27 Text import