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
