From: Achilleas Mantzios <achill@smadev.internal.net>
To: pgsql-sql@postgresql.org
Reply-To: Achilleas Mantzios <achill@smadev.internal.net>
Subject: Re: Correct implementation of 1:n relationship with n>0?
Date: Thu, 02 May 2013 10:45:50 +0300
Message-ID: <6684274.0aeROkWu3T@smadev.internal.net>
Organization: Dynacom Tankers Mgmt
User-Agent: KMail/4.8.4 (FreeBSD/8.3-RELEASE; KDE/4.8.4; amd64; ; )
In-Reply-To: <20130430202542.a68c8042be92943866afa16c@gmx.net>
References: <20130430163905.77d43412c0176c3d9ebd8d90@gmx.net>
	<3724312.iEkiItIUeG@smadev.internal.net>
	<20130430202542.a68c8042be92943866afa16c@gmx.net>
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset="US-ASCII"
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

On =D4=F1=E9 30 =C1=F0=F1 2013 20:25:42 Wolfgang Keller wrote:
> > (there is nothing wrong in getting your hands dirty with pl/pgsql btw)
>=20
> The point is that I would have expected that problem to be solved
> within the past four decades since relational databases have been
> invented. Or at least in the past two decades since PostgreSQL has been
> developed.
>=20

Then what about n>1, n>2, n>k where k an arbitrarily large positive integer?
isn't it the same problem class actually?

Is there any serious database vendor who provides out of the box support fo=
r 1:n, n>0 ?
Or is it an "unusual" user requirement in the first place.
Ever thought why not so many people have asked for this?

Anyway, IMHO, the need for more programming/programmers increases with the =
years,
engineering becomes more complex, you can't expect serious contgrol in anyt=
hing without=20
getting under the hood.

> >;->
>=20
> After all, this should be really an ultra-classic-standard FAQ item.
>=20
> I'm definitely not the first database user in the world who needs to
> have a 1:n relationship with n>0 and integrity enforced by the
> database.
>=20
> Sincerely,
>=20
> Wolfgang
>=20
>=20
>=20
-
Achilleas Mantzios
IT DEV
IT DEPT


--=20
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql