Hello what is version of your postgresql? regards Pavel Stehule 2008/7/20 Suresh_ <suiyengar@xxxxxxxxx>: > > I get this error > > ERROR: syntax error at or near "cursor" > CONTEXT: invalid type name "scroll cursor for select * from tpcd.customer" > compile of PL/pgSQL function "udf" near line 5 > > > Douglas McNaught wrote: >> >> On Fri, Jul 18, 2008 at 12:07 PM, Suresh_ <suiyengar@xxxxxxxxx> 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 >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> >> > > -- > View this message in context: http://www.nabble.com/Writing-a-user-defined-function-tp18532591p18551845.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
