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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
