composite type and assignment in plpgsql

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: composite type and assignment in plpgsql
Date: 2004-04-27 14:25:06
Message-ID: 20040427162506.10d9222c@stige.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luiz Rafael Culik Guimaraes 2004-04-27 14:48:48 query optimizer dont treat correctly OR
Previous Message Timothy Perrigo 2004-04-27 14:19:34 Re: questions on rules