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.
adam
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
