Hello,<br /> I am very new to the postgres sql, i am trying to execute below pl/sql block in postgres but i am getting
error<b>'ERROR: syntax error at or near "integer" '</b>, Could some one help me in this regard<br /><br /> declare<br
/>v_count integer;<br /> begin<br /> select count(1) into v_count from pg_index inx where inx.indexrelid in<br />
(selectoid from pg_class where relname='action_pk' and relowner in <br /> (select oid from pg_authid where
rolname='postgres_ref'))<br /> and inx.indrelid in <br /> (select oid from pg_class where relname='action' and
relownerin <br /> (select oid from pg_authid where rolname='postgres_ref')); <br /><br /> if v_count = 0 then <br />
executeimmediate 'create unique index action_pk <br /> on action(acn_id)'; <br /> end if; <br /> end<br /><br /><br
/><br/><div class="moz-signature"></div><p style="margin-bottom: 0in;"><strong><font color="#939598"><font
face="Arial"><fontsize="2">Sivannarayanareddy Nusum</font></font></font></strong><strong><font color="#000080">
</font></strong><strong><fontcolor="#000080"><font face="Arial"><font size="2">|
</font></font></font></strong><strong><fontcolor="#0000ff"><font face="Arial"><font size="2">System Analyst(Moneta
GDO)</font></font></font></strong><fontcolor="#000080"> </font><p style="margin-bottom: 0in;"><font face="Arial"><font
size="1"style="font-size: 8pt;"><img align="BOTTOM" border="0" height="71" name="graphics1"
src="cid:part1.03010108.07030708@subexworld.com"width="190" /></font></font><p style="margin-bottom: 0in;"><font
color="#808080"><fontface="Arial"><font size="1" style="font-size: 8pt;">Subex Limited, Adarsh Tech Park, Outer Ring
Road,Devarabisannalli, Bangalore – 560037, India.<br /></font></font></font><font color="#a01e55"><font
face="Arial"><fontsize="1" style="font-size: 8pt;"><b>Phone:</b></font></font></font><font color="#000000">
</font><fontcolor="#000000"><font face="Arial"><font size="1" style="font-size: 8pt;">+91 80 6696 3371;
</font></font></font><fontcolor="#a01e55"><font face="Arial"><font size="1" style="font-size:
8pt;"><b>Mobile:</b></font></font></font><fontcolor="#000000"> </font><font color="#000000"><font face="Arial"><font
size="1"style="font-size: 8pt;">+91 9902065831</font></font></font><font color="#c1272d"> </font><font
color="#a01e55"><fontface="Arial"><font size="1" style="font-size:
8pt;"><b>Fax:</b></font></font></font><fontcolor="#000000"> </font><font color="#000000"><font face="Arial"><font
size="1"style="font-size: 8pt;">+91 80 6696 3333; </font></font></font><p style="margin-bottom: 0in;"><font
color="#a01e55"><fontface="Arial"><font size="1" style="font-size: 8pt;"><b>Email:</b></font></font></font><font
color="#c1272d"> </font><font color="#c1272d"><font face="Arial"><font size="1" style="font-size: 8pt;"><a
href="mailto:email.id@subexworld.com">sivannarayanreddy@subexworld.com</a>;</font></font></font><font
color="#a01e55"><fontface="Arial"><font size="1" style="font-size: 8pt;"><b>URL:</b></font></font></font><font
color="#c1272d"> </font><a href="http://www.subexworld.com/"><font color="#c1272d"><font face="Arial"><font size="1"
style="font-size: 8pt;">www.subexworld.com</font></font></font></a><font color="#c1272d"> </font><p
style="margin-bottom:0in;"><font color="#c1272d"> </font><p class="msonormal"><font color="#808080"><font
face="Arial"><fontsize="1" style="font-size: 8pt;"><i>Disclaimer: This e-mail is bound by the terms and conditions
describedat </i></font></font></font><a href="http://www.subexworld.com/mail-disclaimer.html"><font face="Arial"><font
size="1"style="font-size: 8pt;"><i>http://www.subexworld.com/mail-disclaimer.html</i></font></font></a><font
color="#808080"><br/></font>
