Re: trecherous subselect needs warning?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: gry(at)ll(dot)mit(dot)edu
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: trecherous subselect needs warning?
Date: 2006-02-07 19:39:17
Message-ID: 28040.1139341157@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

george young <gry(at)ll(dot)mit(dot)edu> writes:
> How about a *documentation* suggestion that sub-queries can be
> very dangerous if one doesn't qualify all column references?
> Maybe with an example like the one that bit me?

I have no objection to a documentation example, but there isn't any
obvious place where it would fit in the manual. Perhaps some sort
of "SQL gotchas" webpage on techdocs would be appropriate.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bryce Nesbitt 2006-02-08 17:14:11 Delete with join -- deleting related table entries?
Previous Message george young 2006-02-07 19:17:51 Re: trecherous subselect needs warning?