Re: Function, that returns set of 2 tables columns - Mailing list pgsql-general

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