Re: 3 SELECTs rolled into 1 ? - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: 3 SELECTs rolled into 1 ?
Date
Msg-id 20080604075546.GB24432@a-kretschmer.de
Whole thread Raw
In response to 3 SELECTs rolled into 1 ?  (Tarlika Elisabeth Schmitz <postgresql@numerixtechnology.de>)
Responses Re: 3 SELECTs rolled into 1 ?
List pgsql-sql
am  Wed, dem 04.06.2008, um  8:41:29 +0100 mailte Tarlika Elisabeth Schmitz folgendes:
> I have 3 similar SELECTs. I am wondering whether they could be rolled
> into one?
> 
> 
> SELECT
>  item.id 
>  department.id || section.id || category.id as x

Syntax error, missing , between the columns ;-)



> FROM item
>  LEFT JOIN product ON ...
>  LEFT JOIN department ON ...
>  LEFT JOIN section ON ...
>  LEFT JOIN category ON ...
> 
> SELECT
>  item.id 
>  department.id || section.id as x
> FROM item
>  LEFT JOIN product ON ...
>  LEFT JOIN department ON ...
>  LEFT JOIN section ON ...
> 
> SELECT
>  item.id 
>  department.id as x
> FROM item
>  LEFT JOIN product ON ...
>  LEFT JOIN department ON ...


If i understand you correctly: use UNION, like 

select foo1 as foo, bar1 as bar from table1 UNION ALL select foo2, bar2 from table2;

The result table contains 2 columns foo and bar and all rows from both
selects.

Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net


pgsql-sql by date:

Previous
From: Tarlika Elisabeth Schmitz
Date:
Subject: 3 SELECTs rolled into 1 ?
Next
From: Gary Stainburn
Date:
Subject: months, intervals and integers