Re: [GENERAL] passing strings to functions

2004-05-10 Thread Tom Lane
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes: > I can't understand how to pass strings to functions. Your problem isn't with the strings, it's with the smallint parameter. The undecorated "1" is an integer not a smallint, and it won't be silently cast in this particular scenario. > Is there a

[GENERAL] passing strings to functions

2004-05-10 Thread Ivan Sergio Borgonovo
I can't understand how to pass strings to functions. create type tSession as ( SessionCode char(32), SessionID char(32), UserIDI integer, SessionN integer ); create or replace function GetSessionCode( char(32), smallint, boolean, varchar(128) ) returns tSession as ' declare ne