Re: About referential integrity.

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: David BOURIAUD <david(dot)bouriaud(at)ac-rouen(dot)fr>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: About referential integrity.
Date: 2002-02-26 19:52:22
Message-ID: 20020226115027.T93006-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


> > 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;
>
> How is this different from:
>
> select *
> from t1 NATURAL JOIN t2;
>
> ???

I think he still wants it to work even if the columns aren't named
the same. In any case, this isn't likely to be reasonable
right now due to the format of that information in the system
tables.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Charles Hauser 2002-02-26 20:42:38 sub SELECT
Previous Message Frank Bax 2002-02-26 19:38:34 Re: [CHALLANGE] Add seconds to a date