Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Using Aliases in Select - Mailing list pgsql-sql

From Christian Rudow
Subject Re: [SQL] Using Aliases in Select
Date
Msg-id 37A5A5EA.48EF2C37@thinx.ch
Whole thread Raw
In response to Re: [SQL] Using Aliases in Select  (Andy Lewis <alewis@themecca.net>)
List pgsql-sql
Tree view 
Andy Lewis wrote:

> select tab1.name, tab1.mytext as text1, tab2.mytext as text2
> from tab1, tab2 where tab1.tab1_id = tab2.tab1_id
> 
> I believe that this will fix it.
> 
> Andy

Yes it does.
My knowledge of SQL all comes from working with Informix databases.
ThanX a lot !

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christian Rudow                 E-Mail: Christian.Rudow@thinx.ch
ThinX networked business services    Stahlrain 10, CH-5200 Brugg
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

pgsql-sql by date:

Previous
From: Andy Lewis
Date:
Subject: Re: [SQL] Using Aliases in Select
Next
From: Michael Olivier
Date:
Subject: few questions about rules: timestamp, new.oid