pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
N-to-N implementation 2+ messages / 2 participants [nested] [flat]
* N-to-N implementation @ 2005-07-21 15:38 Filipe Knoedt <filipe@brasilenergia.com.br> 0 siblings, 1 reply; 2+ messages in thread From: Filipe Knoedt @ 2005-07-21 15:38 UTC (permalink / raw) To: pgsql-admin Hi all, I'd like to set up a discussion (if necessary) about two different ways to implement N-to-N relationships: using a N-to-N intermediary table or, suppose an A and B tables situation, creating the primary key of the table B with the A.id plus a sequencer. I'm thinking on going the second way, but decided to ask the list if anybody sees any potencial problem in it, like for performance or anything. Filipe Knoedt ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: N-to-N implementation @ 2005-07-21 16:02 Oleg Bartunov <oleg@sai.msu.su> parent: Filipe Knoedt <filipe@brasilenergia.com.br> 0 siblings, 0 replies; 2+ messages in thread From: Oleg Bartunov @ 2005-07-21 16:02 UTC (permalink / raw) To: Filipe Knoedt <filipe@brasilenergia.com.br>; +Cc: pgsql-admin On Thu, 21 Jul 2005, Filipe Knoedt wrote: > Hi all, > > I'd like to set up a discussion (if necessary) about two different ways to implement N-to-N relationships: using a N-to-N intermediary table or, suppose an A and B tables situation, creating the primary key of the table B with the A.id plus a sequencer. > > I'm thinking on going the second way, but decided to ask the list if anybody sees any potencial problem in it, like for performance or anything. we use contrib/intarray to avoid joining > > Filipe Knoedt Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-07-21 16:02 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2005-07-21 15:38 N-to-N implementation Filipe Knoedt <filipe@brasilenergia.com.br> 2005-07-21 16:02 ` Oleg Bartunov <oleg@sai.msu.su>
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