Re: composite type and assignment in plpgsql

Ivan Sergio Borgonovo wrote:

>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( ) ) );
>
- md5 takes TEXT as an argument, not a numeric type
- assign each variable of type tSession to its corresponding value:
      thisSession.ty_found := ''t'';
      thisSession.ty_session := md5(CAST((now( )) AS TEXT));
 I haven't looked up the rand() function, but you can see from this how
you would cast it and now() to text.

>    return thisSession;
>end;
>' language plpgsql;
>
>
>thx
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>
>
>
And then you can get the results:
   select * from getsessionid(1);
imperial=#  select * from getsessionid(1);
 ty_found |            ty_session
----------+----------------------------------
 t        | cf76cca2b562a0ead48d3eb3810f51cc
(1 row)


hth

Ron