Re: [GENERAL] composite type and assignment in plpgsql

2004-04-27 Thread Ron St-Pierre
Ivan Sergio Borgonovo wrote: On Tue, 27 Apr 2004 10:12:13 -0700 thisSession := ( ''t'', md5( now( ) || rand( ) ) ); - md5 takes TEXT as an argument, not a numeric type Since it works you surely fixed my code but this should't be an issue since I tried test1=# select md5( now( ) || r

Re: [GENERAL] composite type and assignment in plpgsql

2004-04-27 Thread Ivan Sergio Borgonovo
On Tue, 27 Apr 2004 10:12:13 -0700 Ron St-Pierre <[EMAIL PROTECTED]> wrote: > Ivan Sergio Borgonovo wrote: > > --HERE!!! > > thisSession := ( ''t'', md5( now( ) || rand( ) ) ); > > > - md5 takes TEXT as an argument, not a numeric type Since it works you surely fixed my code but this shou

Re: [GENERAL] composite type and assignment in plpgsql

2004-04-27 Thread Ron St-Pierre
Ron St-Pierre wrote: 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 := ( ''

Re: [GENERAL] composite type and assignment in plpgsql

2004-04-27 Thread Ron St-Pierre
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