Обсуждение: clarififcation

Hai,

I started working on postgresql, I want to know how to write the " connect by" clause of oracle. My problem is i have a table with id, parent id. In same table i will insert the record with parent id as previous row id. I want fetch the records in the hierarchy. how do i do it.

Pls help me. I want to get in touch with developers and then i need to try multi master replication also.

Regards,
Gayathri

Send instant messages to your online friends http://uk.messenger.yahoo.com

gayathri jayapal wrote:
> Hai,
>
> I started working on postgresql, I want to know how to write the "
> connect by" clause of oracle. My problem is i have a table with id,
> parent id. In same table i will insert the record with parent id as
> previous row id. I want fetch the records in the hierarchy. how do i
> do it.

If you installed from source, look in .../contrib/tablefunc/ for an
installable connectby() function. If you installed by package, there is
usually one or more additional packages containing the contrib stuff.

> Pls help me. I want to get in touch with developers and then i need
> to try multi master replication also.

There are no pre-packaged multi-master replication solutions at the
moment. The first thing you'll have to do in building such a solution is
decide on how you want to deal with conflicting updates.

--
   Richard Huxton
   Archonet Ltd