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

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly