Re: How to append tables in a view

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