On Mon, 2005-08-22 at 10:29, Adam Witney wrote: > On 22/8/05 10:19 am, "Nigel Horne" <njh@xxxxxxxxxxxxxx> wrote: > > > On Fri, 2005-08-19 at 17:29, Tom Lane wrote: > >> Adam Witney <awitney@xxxxxxxxxx> writes: > >>> Ah you want to return a record I suppose? > >> > >>> CREATE TABLE test (id int, name text); > >>> INSERT INTO test VALUES(1, 'me'); > >>> INSERT INTO test VALUES(2, 'you'); > >> > >>> CREATE FUNCTION test_func() RETURNS SETOF record AS ' > >>> SELECT id, name FROM test; > >>> ' LANGUAGE SQL; > >> > >> Or better, "RETURNS SETOF test", so you don't have to describe the > >> output record type every time you call it. > > > > Seeing as there will only ever be one row in this table, do I need the > > SETOF field? > > Try it and see.... I think you don't need it for a single row. Another problem comes to mind, how can I make this multi-thread safe? Since the return values from the function are stored in the database I need to ensure that simultaneous calls to the function are stored independently in the temporary table. > adam -Nigel ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
