Re: About referential integrity.

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: BOURIAUD <david(dot)bouriaud(at)ac-rouen(dot)fr>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: About referential integrity.
Date: 2002-02-25 19:15:41
Message-ID: Pine.LNX.4.30.0202251412230.836-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

BOURIAUD writes:

> So, why souldn't I be abble to write :
> select * from t1, t2;
>
> and have the backend returns me only the rows that have t1.key1 = t2.key2 ???

If that's what you want you can write

select * from t1 natural join t2;

--
Peter Eisentraut peter_e(at)gmx(dot)net

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-02-25 19:46:37 Re: [SQL] Sort problem
Previous Message Samuel J. Sutjiono 2002-02-25 19:12:26 Re: [GENERAL] Sort problem