Skip site navigation (1) Skip section navigation (2)

Re: select, columns, and aliases

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: mkl(at)webde-ag(dot)de
Subject: Re: select, columns, and aliases
Date: 2004-07-23 19:51:04
Message-ID: 20040723195104.81534.qmail@web52906.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-general
???

--- Michael Kleiser <mkl(at)webde-ag(dot)de> wrote:
> select a.*, b.*
>   from tablea AS a
>   inner tableb AS b
>   on a.id=b.aid;
> 
> 
> CSN schrieb:
> > Is it possible to automatically prefix a table
> alias
> > (or table name or something else even) to each
> column
> > in a select list? For example:
> > 
> > select a.*, b.*
> > from tablea a
> > inner tableb b
> > on a.id=b.aid;
> > 
> > results:
> > 
> > a_id, a_name, b_id, b_name, b_aid
> > 
> > 
> > CSN
> > 
> > 
> > 	
> > 		
> > __________________________________
> > Do you Yahoo!?
> > Vote for the stars of Yahoo!'s next ad campaign!
> >
>
http://advision.webevents.yahoo.com/yahoo/votelifeengine/
> > 
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the
> unregister command
> >     (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

pgsql-general by date

Next:From: Krzysztof LabiakDate: 2004-07-23 20:48:14
Subject: pg storage system
Previous:From: Tom LaneDate: 2004-07-23 18:33:50
Subject: Re: Postgres "invalid page header"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group