Re: Writing a user defined function

On Fri, Jul 18, 2008 at 12:07 PM, Suresh_ <suiyengar@yahoo.com> wrote:
>
> Hello,
>  I am trying to code a simple udf in postgres. How do I write sql commands
> into pl/sql ? The foll. code doesnt work.
>
> CREATE OR REPLACE FUNCTION udf()
> RETURNS integer AS $$
> BEGIN
> for i in 1..2000 loop
>  for j in 1...10000 loop
>  end loop;
>  begin work;

Postgres doesn't let you do transactions inside a function.

Take out the BEGIN and COMMIT, and if you still get errors post the
function code and the error message that you get.

-Doug