Re: [SQL] stored procedures in postgresql user plpgsql

2004-11-29 Thread Michael Fuhr
Please Cc the mailing list when you respond -- that way others can participate in and learn from the discussion. Also, if you have a new question then please start a new thread with a relevant Subject header. On Mon, Nov 29, 2004 at 10:12:59PM -0500, [EMAIL PROTECTED] wrote: > Thanks for the help

Re: [SQL] stored procedures in postgresql user plpgsql

2004-11-29 Thread Michael Fuhr
On Mon, Nov 29, 2004 at 01:37:42PM -0500, [EMAIL PROTECTED] wrote: > I have tried to create a simple function to select data from a table. Could > you all please correct me It would be helpful if you told us what you want to happen and what actually does happen. Without that information we have

[SQL] stored procedures in postgresql user plpgsql

2004-11-29 Thread RobertD . Stewart
I know that there are not stored procedures like that in oracle. I know that you have to create functions.   I have tried to create a simple function to select data from a table.  Could you all please correct me   Thanks     CREATE FUNCTION retrive_atype(varchar) RETURNS varchar AS '