Re: [GENERAL] question about stored procedure / function

2007-03-11 Thread Bill Moran
"Alain Roger" <[EMAIL PROTECTED]> wrote: > > Hi, > > i created the following function : > -- Function: immense.sp_a_001(username "varchar", pwd "varchar") > -- DROP FUNCTION immense.sp_a_001(username "varchar", pwd "varchar"); > > CREATE OR REPLACE FUNCTION immense.sp_a_001(username "varchar", pw

Re: [GENERAL] question about stored procedure / function

2007-03-11 Thread Anton Melser
On 11/03/07, Alain Roger <[EMAIL PROTECTED]> wrote: Hi, i created the following function : -- Function: immense.sp_a_001(username "varchar", pwd "varchar") -- DROP FUNCTION immense.sp_a_001(username "varchar", pwd "varchar"); CREATE OR REPLACE FUNCTION immense.sp_a_001(username "varchar", pwd "

[GENERAL] question about stored procedure / function

2007-03-11 Thread Alain Roger
Hi, i created the following function : -- Function: immense.sp_a_001(username "varchar", pwd "varchar") -- DROP FUNCTION immense.sp_a_001(username "varchar", pwd "varchar"); CREATE OR REPLACE FUNCTION immense.sp_a_001(username "varchar", pwd "varchar") RETURNS int4 AS $BODY$ DECLARE myrec imme