| 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: | Whole Thread | Raw Message | 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, |