"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
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
I have read the docs on converting Oracle to Postgres already. I'm a little
confused though. I have a procedure in Oracle that just does some
calculations and then does an update based on the calculations. The
procedure doesn't return anything. It seems like in Postgres that everything
has to b
