Re: [SQL] PL/SQL block error

2011-02-16 Thread Pavel Stehule
Hello you should to wrap code to function or inline function everywhere. psql doesn't support PL/SQL and doesn't support inlined PL/SQL blocks. Regards Pavel Stehule 2011/2/16 Sivannarayanreddy > Hello, > I am very new to the postgres sql, i am trying to execute below pl/sql > block in post

[SQL] PL/SQL block error

2011-02-16 Thread Sivannarayanreddy
Title: Hello, I am very new to the postgres sql, i am trying to execute below pl/sql block in postgres but i am getting error 'ERROR:  syntax error at or near "integer" ', Could some one help me in this regard declare v_count integer; begin selec