Received: from necker.ac-rouen.fr (smtp.ac-rouen.fr [194.167.110.3]) by postgresql.org (Postfix) with ESMTP id A454B47546E for ; Tue, 26 Feb 2002 02:52:16 -0500 (EST) Received: from there (localhost.localdomain [127.0.0.1]) by necker.ac-rouen.fr (8.11.0/8.11.0) with SMTP id g1Q7rdx22057 for ; Tue, 26 Feb 2002 08:53:40 +0100 Message-Id: <200202260753.g1Q7rdx22057@necker.ac-rouen.fr> Content-Type: text/plain; charset="iso-8859-1" From: David BOURIAUD Organization: Inspection =?iso8859-1?q?acad=E9mique=20de?= l'Eure To: pgsql-sql@postgresql.org Subject: Re: About referential integrity. Date: Tue, 26 Feb 2002 08:51:30 +0100 X-Mailer: KMail [version 1.3.2] References: <200202251503.g1PF3vn21366@necker.ac-rouen.fr> In-Reply-To: <200202251503.g1PF3vn21366@necker.ac-rouen.fr> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200202/389 X-Sequence-Number: 6811 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