Re: Function, that returns set of 2 tables columns

am Tue, dem 13.02.2007, um 16:09:16 +0200 mailte Dmitriy Chumack folgendes:
> Tuesday, February 13, 2007, 3:55:36 PM, Andreas Kretschmer:
>
> > 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
>
>
> But how this solve my problem? I don't need standalone select, I need
> this select to be wrapped in function, and function has to return some
> type.

Do you need the columns from both tables in one single column? Then you
have to join this tables, i don't know how you want to join this tables.

What i meant was:

you can use this:

for i in select * from "Table1" union all select * from "Table2" loop
-- do something
end loop;

within a pl/pgsql-function.

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