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
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, |