Michael Fuhr <mike@xxxxxxxx> writes: > On Sun, Apr 24, 2005 at 11:05:57PM -0500, Tony Caduto wrote: >> Is the syntax going to be exactly like it is in Oracle? > I'm not familiar with the Oracle syntax and I don't know how close > the PostgreSQL implementation is to being final, but here's an > example that works with the most recent code from HEAD (8.1devel): > CREATE FUNCTION foo(IN x integer, INOUT y integer, OUT z integer) AS $$ FWIW, we will also take the more Oracle-ish spelling of the parameter list: CREATE FUNCTION foo(x IN integer, y IN OUT integer, z OUT integer) AS ... ... although given all the other in-detail discrepancies between plpgsql and Oracle's pl/sql, I'm not sure how much this will really make anyone's life easier. In any case, Michael's example is the preferred syntax because it is what the SQL spec calls for. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
