From: | Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | composite types |
Date: | 2004-04-20 15:41:30 |
Message-ID: | 20040420174130.2cace9ea@stige.webthatworks.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'd like to compute some "row like" results and return them from a
function (and pass the result to PHP[*]).
Well I've read about composite type but all the references I've seen
are about coding in C. That's not the way I'd like to follow by now.
I was expecting to declare composite types in plpsql or plain sql in a
similar way I'd do in C/C++ with struct/class.
I've found this
http://archives.postgresql.org/pgsql-general/2001-03/msg01459.php
but I'd like to avoid to declare a table just for a temp.
pseudocode follow
declare struct pippo(
integer a;
varchar(8) b;
)
create or replace function functiontest( ) returns pippo
as '
declare
integer tempa;
varchar(8) tempb;
begin
/*
do stuff to fill tempa and tempb
*/
return (tempa,tempb)
end
' language plpgsql;
[*] I guess that to access the result of such a function
...
$SQLResult = pg_exec( $SQLConn, "SELECT functiontest( );" );
$SQLData = pg_fetch_row( $SQLResult, 0 );
should be enough...
thx
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2004-04-20 15:44:28 | Re: plan-reading extensive tutorial? |
Previous Message | Joe Conway | 2004-04-20 15:37:39 | Re: [OT] Tom's/Marc's spam filters? |