Implicit RTEs

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Postgres Hackers List <hackers(at)postgresql(dot)org>
Subject: Implicit RTEs
Date: 2000-02-06 16:55:36
Message-ID: 389DA788.CA1CF761@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I know this topic came up recently:

select t1.* from t1 ty;

gives a join between two instances of t1, rather than the expected
query rejection (the table in the from clause should be referred to as
"ty").

There was talk of disallowing:

select t1.*;

which seems to be a bit harsh, since it is a *nice* shorthand. How
about disallowing it if there is a FROM clause specified? That is,

select t1.*;

is allowed, but

select t1.* from t2;

is not? Pretty sure I can do this. Comments?

- Thomas

--
Thomas Lockhart lockhart(at)alumni(dot)caltech(dot)edu
South Pasadena, California

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 2000-02-06 17:29:38 Duplicate table names
Previous Message Thomas Lockhart 2000-02-06 16:50:26 Re: [HACKERS] Advice needed,