Re: About referential integrity. - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: About referential integrity.
Date
Msg-id Pine.LNX.4.30.0202251412230.836-100000@peter.localdomain
Whole thread Raw
In response to About referential integrity.  (BOURIAUD <david.bouriaud@ac-rouen.fr>)
List 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@gmx.net



pgsql-sql by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: About referential integrity.
Next
From: "Samuel J. Sutjiono"
Date:
Subject: Re: [GENERAL] Sort problem