Re: How to append tables in a view

I guess UNION ALL should work good here instead of a UNION for the exact
same kind of output he needs:

SELECT id,desc FROM table1
UNION ALL
SELECT id,desc FROM table2;

---+---
1 | A
2 | B
3 | C
1 | D
2 | E
3 | F

As UNION gave me a little different output, like this:

---+--
1 | A
1 | D
2 | B
2 | E
3 | C
3 | F

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 2/13/07, Shane Ambler <pgsql(at)007marketing(dot)com> wrote:
>
> Ashish Karalkar wrote:
> > Hello List,
> >
> > I want to append column of two different tables in a single column of a
> view .
> >
> > data type of tow column of two diffrent tables will be same.
> >
> > WHAT I WANT TO DO IS:
> >
> > Table 1
> > ID DESC
> > 1 A
> > 2 B
> > 3 C
> >
> >
> >
> >
> >
> > Table 2
> > ID DESC
> > 1 D
> > 2 E
> > 3 F
> >
> >
> >
> > View(Table1|| Table 2)
> > ID_view Desc
> >
> > 1 A
> > 2 B
> > 3 C
> > 4 D
> > 5 E
> > 6 F
> >
> >
> >
> > Is there any way???
>
> A union -
>
> SELECT id,desc FROM table1
> UNION
> SELECT id,desc FROM table2;
>
> This will give you
>
> ID_view Desc
>
> 1 A
> 2 B
> 3 C
> 1 D
> 2 E
> 3 F
>
>
> If you actually want the id_view column to show 1 through 6 then you
> will want to generate a sequence that is shown for that column instead
> of the original id column. Or generate the id_view in the client, such
> as use the row position in the returned set.
>
>
>
>
> --
>
> Shane Ambler
> pgSQL(at)007Marketing(dot)com
>
> Get Sheeky @ http://Sheeky.Biz
>