From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Suresh_ <suiyengar(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Writing a user defined function |
Date: | 2008-07-20 08:33:44 |
Message-ID: | 162867790807200133r480571b0u501140d3683d1a0d@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
what is version of your postgresql?
regards
Pavel Stehule
2008/7/20 Suresh_ <suiyengar(at)yahoo(dot)com>:
>
> 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(at)yahoo(dot)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
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Suresh | 2008-07-20 14:59:08 | Re: Writing a user defined function |
Previous Message | Suresh_ | 2008-07-20 06:44:59 | Re: Writing a user defined function |