Re: Function, that returns set of 2 tables columns

["A. Kretschmer" <andreas.kretschmer@xxxxxxxxxxxxxx>]

am  Tue, dem 13.02.2007, um 15:46:19 +0200 mailte Dmitriy Chumack folgendes:
> Hi *
> 
>   I need to write a function, that returns a set of all columns from 2
>   tables.
> 
>   e.g. I create such a function:
> 
>     CREATE OR REPLACE FUNCTION func(val_ int8)
>       RETURNS SETOF record AS
>     $BODY$
>     DECLARE
>         i record;
>     BEGIN
> 
>     for i in select * from "Table1", "Table2"

Use something like:

select * from table1 union all select * from table2


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