From: David BOURIAUD <david.bouriaud@ac-rouen.fr>
To: pgsql-sql@postgresql.org
Subject: Re: About referential integrity.
Date: Tue, 26 Feb 2002 08:51:30 +0100
Message-ID: <200202260753.g1Q7rdx22057@necker.ac-rouen.fr> (raw)
In-Reply-To: <200202251503.g1PF3vn21366@necker.ac-rouen.fr>
References: <200202251503.g1PF3vn21366@necker.ac-rouen.fr>
Le Lundi 25 Février 2002 16:01, vous avez écrit :
Hi to all !
First of all, thanks to the ones who answered me, for I didn't know that it
wasn't a SQL specification, though I suspected it, and I didn't even suspect
that it could roughly done with the "NATURAL JOIN" specificated in the "FROM"
clause.
Anyway, couldn't it be an extention to postgreSQL ? If you have heard about
Business Objects, you should know that it can do it very well provided you
draw the relationchips between the tables of your database. And it's of much
use, since you just have to concentrate on the fields you want to fetch and
the program takes care of the relations and handles group by, order by and
where clause.
As of PostgreSQL, I don't think it would be a hard thing to put on, since the
relations are stored in a system table, including the fields the tables are
linked by. A sort of syntax :
select *
from AUTO JOIN t1, t2;
should do the stuff, and leave the SQL/92 and 99 specifications alone !
--
David BOURIAUD
----------------------------------------------------------
In a world without walls or fences, what use do we have
for windows or gates ?
----------------------------------------------------------
ICQ#102562021
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: david.bouriaud@ac-rouen.fr
Subject: Re: About referential integrity.
In-Reply-To: <200202260753.g1Q7rdx22057@necker.ac-rouen.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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