| From: | Murat Tasan <murat(dot)tasan(at)cwru(dot)edu> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | function return type is a setof some column type |
| Date: | 2006-01-30 23:19:00 |
| Message-ID: | 18226A8C-71D1-48D0-ADA1-273259B6932D@cwru.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
hi all, i'm new to the list, so if this is an off-topic question, or
has already been posed, i apologize...
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;
yet i know the %TYPE format works because the below succeeds...
CREATE FUNCTION test_function() RETURNS table.column%TYPE AS $$
SELECT 1; $$ LANGUAGE SQL;
as does the SETOF option because the following also succeeds...
CREATE FUNCTION test_function() RETURNS SETOF int4 AS $$ SELECT 1; $$
LANGUAGE SQL;
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!
murat
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Web2cad | 2006-01-31 00:24:30 | Re: put text list into table form |
| Previous Message | operationsengineer1 | 2006-01-30 20:26:44 | Re: Upgrade to PG 8 before starting major development? |