am Mon, dem 30.04.2007, um 15:45:18 +0200 mailte Heiko Klein folgendes: > Hi, > > I'm trying to select data from a table, converting two values and return > all four. Maybe this is best explained with an example: > > The function from the documentation on pl/pgsql: > > CREATE FUNCTION sum_n_product(x int, y int, OUT sum int, OUT prod int) AS $$ > BEGIN > sum := x + y; > prod := x * y; > END; > $$ LANGUAGE plpgsql; > > And a table 'myvals' with x and y integer values: > CREATE TABLE myvals (INT x, INT y); > > > How can I do the following: > > select * from myvals, sum_n_product(myvals.x, myvals.y); select x, y, sum_n_product(x,y) from myvals; Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
