Re: [SQL] table aliasing problem with 6.5... - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: [SQL] table aliasing problem with 6.5...
Date
Msg-id 199909280448.AAA01722@candle.pha.pa.us
Whole thread Raw
In response to Re: [SQL] table aliasing problem with 6.5...  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [SQL] table aliasing problem with 6.5...  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
> > I am interested in comments about my wording, and this behavour.
> 
> I think this is a fine idea, but that wording might not be much help
> to novices.  Maybe "Adding missing FROM-clause entry for pg_language",
> or some such?

Wording change to your version.

> 
> In a situation where you've got subselects, it may not be immediately
> obvious which FROM list the entry got added to.  I can't think of any
> simple way of identifying that, however :-(

Not sure how to handle that either.  I could print the subquery level
number, or I could say "in subquery" or even go fancy and do "in
sub-sub-query" depending on the number of levels down.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: Haris Susanto
Date:
Subject: pqReadData()
Next
From: Sebestyen Zoltan
Date:
Subject: Re: [SQL] pg_dumpall + psql -e template1