Re: [SQL] converting an oracle procedure to postgres

2003-10-20 Thread Tom Lane
"Clint Stotesbery" <[EMAIL PROTECTED]> writes: > I know I have to relpace the word PROCEDURE with FUNCTION but then it wants > me to put RETURNS but I don't want to return anything. You can say RETURNS VOID in recent releases. This is a bit of a hack but it expresses your intent ... you still h

Re: [SQL] converting an oracle procedure to postgres

2003-10-20 Thread Josh Berkus
Clint, > v_taxstatus varchar(1); > v_shipping varchar(12); Drop the varchar limits, it's not supported inside PL/pgSQL. > I know I have to relpace the word PROCEDURE with FUNCTION but then it wants > me to put RETURNS but I don't want to return anything. I was > thinking that I