pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
clarififcation
2+ messages / 2 participants
[nested] [flat]

* clarififcation
@ 2007-02-14 09:22  gayathri jayapal <jgayathrisen@yahoo.com>
  0 siblings, 1 reply; 2+ messages in thread

From: gayathri jayapal @ 2007-02-14 09:22 UTC (permalink / raw)
  To: pgsql-admin; pgsql-general@postgresql.org

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 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [GENERAL] clarififcation
@ 2007-02-15 17:49  Richard Huxton <dev@archonet.com>
  parent: gayathri jayapal <jgayathrisen@yahoo.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2007-02-15 17:49 UTC (permalink / raw)
  To: gayathri jayapal <jgayathrisen@yahoo.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2007-02-15 17:49 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-14 09:22 clarififcation gayathri jayapal <jgayathrisen@yahoo.com>
2007-02-15 17:49 ` Richard Huxton <dev@archonet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox