Re: trecherous subselect needs warning? - Mailing list pgsql-sql

From Tom Lane
Subject Re: trecherous subselect needs warning?
Date
Msg-id 28040.1139341157@sss.pgh.pa.us
Whole thread Raw
In response to Re: trecherous subselect needs warning?  (george young <gry@ll.mit.edu>)
List pgsql-sql
george young <gry@ll.mit.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


pgsql-sql by date:

Previous
From: george young
Date:
Subject: Re: trecherous subselect needs warning?
Next
From: Bryce Nesbitt
Date:
Subject: Delete with join -- deleting related table entries?