composite type and assignment in plpgsql - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject composite type and assignment in plpgsql
Date
Msg-id 20040427162506.10d9222c@stige.webthatworks.it
Whole thread Raw
Responses Re: composite type and assignment in plpgsql
List pgsql-general
what's wrong with this?

create type tSession
    as ( ty_found boolean, ty_Session char(32) );

create or replace function GetSessionID( integer )
    returns tSession as '
declare
    thisSession tSession;
begin
    --HERE!!!
    thisSession := ( ''t'', md5( now( ) || rand( ) ) );
    return thisSession;
end;
' language plpgsql;


thx


pgsql-general by date:

Previous
From: Timothy Perrigo
Date:
Subject: Re: questions on rules
Next
From: Shanmugasundaram Doraisamy
Date:
Subject: Problem installing postgresql 7.3.6 on Redhat 7.3