Re: [HACKERS] column aliases - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] column aliases
Date
Msg-id 200001241629.LAA16455@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] column aliases  (Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at>)
Responses Re: [HACKERS] column aliases
List pgsql-hackers
> > >This may go a long way towards explaining why people have been so
> > >readily confused by the implicit-FROM-clause business! 
> > 
> > It *is* confusing, that's for sure!
> 
> IMHO, if there exists a from clause, we could insist,
> that all tables are listed (no implicitly added table),
> since it is really too error prone.
> 
> What I would not like to see removed is the ability to 
> avoid the from clause alltogether. Like in:
> 
> select xor.eval;

This is an interesting suggestion.  I wonder if we can do this.  We can
avoid producing NOTICE messages in this case.

--  Bruce Momjian                        |  http://www.op.net/~candle pgman@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-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] fatal copy in/out error (6.5.3)
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] Well, then you keep your darn columns