Hello,

i must port a project from Oracle to PostgreSQL and has following
problem:

in Oracle i do following:

SELECT * FROM TABLE
START WITH ID IN (1,2,3,4)
CONNECT BY ID_PARENT = prior ID;

In PostgreSQL i found the function connectby(), but there can i give
only one start value :,-(

Any idea? If not, that reduces the speed of my search function extremely!

---------------------------------------------
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer

Ok, an new begin with a new question. How can
i pass unknown count of parameters to a function.
They have all the same type. With a array or record?

I can not found it :,-(
---------------------------------------------
Thomas Wegner
Cabrio Meter - The Weather Plugin for Trillian
http://trillian.wegner24.de/cabriometer

"Thomas Wegner" <tomaten [at] t-online.de> schrieb im Newsbeitrag
news:ceaj7b$ffr$1 [at] news.hub.org...
> Hello,
>
> i must port a project from Oracle to PostgreSQL and has following
> problem:
>
> in Oracle i do following:
>
> SELECT * FROM TABLE
> START WITH ID IN (1,2,3,4)
> CONNECT BY ID_PARENT = prior ID;
>
> In PostgreSQL i found the function connectby(), but there can i give
> only one start value :,-(
>
> Any idea? If not, that reduces the speed of my search function extremely!
>
> ---------------------------------------------
> Thomas Wegner
> Cabrio Meter - The Weather Plugin for Trillian
> http://trillian.wegner24.de/cabriometer
>
>