From: | "mmuurr[AT]gmail(dot)com" <mmuurr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | function returns setof column type problems |
Date: | 2006-01-31 15:48:11 |
Message-ID: | 1138722491.367926.123850@g14g2000cwa.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
hi all,
i'm trying to figure out how to get the following test situation to
work:
creating a function like below fails...
=> CREATE FUNCTION test_function() RETURNS SETOF table.column%TYPE AS
$$ SELECT 1; $$ LANGUAGE SQL;
ERROR: syntax error at or near "%" at character 59
LINE 1: ...ate function test_function() returns setof table.column%TYPE
as $...
yet i know the %TYPE format works because the below succeeds...
=> CREATE FUNCTION test_function() RETURNS table.column%TYPE AS $$
SELECT 1; $$ LANGUAGE SQL;
NOTICE: type reference table.column%TYPE converted to integer
CREATE FUNCTION
as does the SETOF option because the following also succeeds...
=> CREATE FUNCTION test_function() RETURNS SETOF int4 AS $$ SELECT 1;
$$ LANGUAGE SQL;
CREATE FUNCTION
can anyone help me figure out how to get the first function declaration
to work?
and yes, i know i could just look up the type of the column of
interest, but i'm trying to make the function somewhat independent of
table alterations (the whole reason for the %TYPE inclusion in
postgresql in the first place!)
thanks for any help!
From | Date | Subject | |
---|---|---|---|
Next Message | Rick Gigger | 2006-01-31 15:56:01 | Re: New project launched : PostgreSQL GUI Installer for |
Previous Message | Thomas Hallgren | 2006-01-31 15:37:57 | Re: [GENERAL] New project launched : PostgreSQL GUI |