From sivannarayanreddy@subexworld.com Wed Feb  16 12:35:25 2011
Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 69B2A13364DE
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 16 Feb 2011 08:35:25 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 60768-06 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 16 Feb 2011 12:35:17 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from cx296.800onemail.com (CX296.800onemail.com [209.171.54.154])
	by mail.postgresql.org (Postfix) with ESMTP id 22FDF133616B
	for <pgsql-sql@postgresql.org>; Wed, 16 Feb 2011 08:35:17 -0400 (AST)
Received: from EX13-N05.exchserver.com ([10.7.5.66])
	by cx296.800onemail.com (8.13.8/8.13.8) with ESMTP id p1GCXvQZ025280
	for <pgsql-sql@postgresql.org>; Wed, 16 Feb 2011 07:33:57 -0500
Received: from EX60.exchserver.com (10.7.5.154) by EX13-N05.exchserver.com
	(10.7.40.162) with Microsoft SMTP Server id 8.3.106.1; Wed, 16 Feb 2011
	07:33:57 -0500
Received: from [127.0.0.1] ([164.164.82.29]) by EX60.exchserver.com with
	Microsoft SMTPSVC(6.0.3790.3959);	 Wed, 16 Feb 2011 07:33:56 -0500
Message-ID: <4D5BC495.5000605@subexworld.com>
Date: Wed, 16 Feb 2011 18:05:33 +0530
From: Sivannarayanreddy <sivannarayanreddy@subexworld.com>
Reply-To: sivannarayanreddy@subexworld.com
Organization: Subex Ltd.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Function compile error
Content-Type: multipart/alternative;
	boundary="------------010503060009070302060100"
X-OriginalArrivalTime: 16 Feb 2011 12:33:56.0596 (UTC)
	FILETIME=[C7520340:01CBCDD5]
X-Crx-NoRoute: SMTP reroute not required
X-CRXEFW-Info: Please contact Ceryx for more information
X-CRXEFW-Virus: Clean
X-CRXEFW-From: sivannarayanreddy@subexworld.com
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201102/79
X-Sequence-Number: 35155

--------------010503060009070302060100
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit

Hello,
I am trying to create the function as below but it is throwing error 
'ERROR:  syntax error at or near "DECLARE"', Could some one help me please

CREATE FUNCTION check_password(databasename text, tablename text, 
indexname text)RETURNS VOID AS
DECLARE v_count INTEGER;
BEGIN
   select  count(1) into v_count  from  pg_index inx where  
inx.indexrelid in
  (select oid from pg_class where relname=$3 and relowner in
  (select oid from pg_authid where rolname=$1))
  and inx.indrelid in
  (select oid from pg_class where relname=$2 and relowner in
  (select oid from pg_authid where rolname=$1));
  if v_count = 0 then
execute immediate 'create unique index $3 on $2 (acn_id)';
end if;
END;

*Sivannarayanareddy Nusum****| **System Analyst(Moneta GDO)*

Subex Limited, Adarsh Tech Park, Outer Ring Road, Devarabisannalli, 
Bangalore -- 560037, India.
*Phone:*+91 80 6696 3371; *Mobile:*+91 9902065831*Fax:*+91 80 6696 3333;

*Email:*sivannarayanreddy@subexworld.com 
<mailto:email.id@subexworld.com>; *URL:*www.subexworld.com 
<http://www.subexworld.com/>

/Disclaimer: This e-mail is bound by the terms and conditions described 
at //http://www.subexworld.com/mail-disclaimer.html/


--------------010503060009070302060100
Content-Type: multipart/related;
	boundary="------------090706030207000604070201"

--------------090706030207000604070201
Content-Type: text/html; charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
  </head>
  <body text="#000099" bgcolor="#ffffff">
    <tt>Hello,<br>
      I am trying to create the function as below but it is throwing
      error 'ERROR:&nbsp; syntax error at or near "DECLARE"', Could some one
      help me please<br>
      <br>
      CREATE FUNCTION check_password(databasename text, tablename text,
      indexname text)RETURNS VOID AS <br>
      DECLARE v_count INTEGER;<br>
      BEGIN<br>
      &nbsp; select&nbsp; count(1) into v_count&nbsp; from&nbsp; pg_index inx where&nbsp;
      inx.indexrelid in<br>
      &nbsp;(select oid from pg_class where relname=$3 and relowner in <br>
      &nbsp;(select oid from pg_authid where rolname=$1)) <br>
      &nbsp;and inx.indrelid in <br>
      &nbsp;(select oid from pg_class where relname=$2 and relowner in <br>
      &nbsp;(select oid from pg_authid where rolname=$1)); <br>
      &nbsp;if v_count = 0 then&nbsp; <br>
      execute immediate 'create unique index $3 on $2 (acn_id)';&nbsp; <br>
      end if; <br>
      END;</tt><br>
    <div class="moz-signature"><br>
      <meta http-equiv="CONTENT-TYPE" content="text/html;
        charset=ISO-8859-1">
      <title> </title>
      <meta name="GENERATOR" content="OpenOffice.org 2.3 (Win32)">
      <meta name="CREATED" content="0;0">
      <meta name="CHANGED" content="20090514;17180285">
      <meta name="ProgId" content="Word.Document">
      <meta name="Originator" content="Microsoft Word 11">
      <!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
      <!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>Connoi</o:Author>
  <o:Template>Normal</o:Template>
  <o:LastAuthor>harshitan</o:LastAuthor>
  <o:Revision>2</o:Revision>
  <o:TotalTime>4</o:TotalTime>
  <o:Created>2007-11-30T08:17:00Z</o:Created>
  <o:LastSaved>2007-11-30T08:17:00Z</o:LastSaved>
  <o:Pages>1</o:Pages>
  <o:Words>80</o:Words>
  <o:Characters>459</o:Characters>
  <o:Lines>3</o:Lines>
  <o:Paragraphs>1</o:Paragraphs>
  <o:CharactersWithSpaces>538</o:CharactersWithSpaces>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
</xml><![endif]-->
      <!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:ValidateAgainstSchemas/>
  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
  <w:Compatibility>
   <w:SelectEntireFieldWithStartOrEnd/>
   <w:UseWord2002TableStyleRules/>
  </w:Compatibility>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]-->
      <!--[if gte mso 9]><xml>
 <w:LatentStyles DefLockedState="false" LatentStyleCount="156">
 </w:LatentStyles>
</xml><![endif]-->
      <!--[if !mso]><object
 classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object>
<style>
st1\:*{behavior:url(#ieooui) }
</style>
<![endif]-->
      <!--[if gte mso 10]>
<style>
 /* Style Definitions */
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";
	mso-ansi-language:#0400;
	mso-fareast-language:#0400;
	mso-bidi-language:#0400;}
</style>
<![endif]-->
      <!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="2050"/>
</xml><![endif]-->
      <!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1"/>
 </o:shapelayout></xml><![endif]-->
      <style type="text/css">
	<!--
		@page { size: 8.5in 11in }
		P { color: #000000 }
		A:link { color: #0000ff }
		A:visited { color: #800080 }
	-->
	</style>
      <p style="margin-bottom: 0in;"><strong><font color="#939598"><font
              face="Arial"><font size="2">Sivannarayanareddy
                Nusum</font></font></font></strong><strong><font
            color="#000080"> </font></strong><strong><font
            color="#000080"><font face="Arial"><font size="2">|
              </font></font></font></strong><strong><font
            color="#0000ff"><font face="Arial"><font size="2">System
                Analyst(Moneta GDO)</font></font></font></strong><font
          color="#000080">
        </font>
      </p>
      <p style="margin-bottom: 0in;"><font face="Arial"><font
            style="font-size: 8pt;" size="1"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75"
 o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
 <v:stroke joinstyle="miter"/>
 <v:formulas>
  <v:f eqn="if lineDrawn pixelLineWidth 0"/>
  <v:f eqn="sum @0 1 0"/>
  <v:f eqn="sum 0 0 @1"/>
  <v:f eqn="prod @2 1 2"/>
  <v:f eqn="prod @3 21600 pixelWidth"/>
  <v:f eqn="prod @3 21600 pixelHeight"/>
  <v:f eqn="sum @0 0 1"/>
  <v:f eqn="prod @6 1 2"/>
  <v:f eqn="prod @7 21600 pixelWidth"/>
  <v:f eqn="sum @8 21600 0"/>
  <v:f eqn="prod @7 21600 pixelHeight"/>
  <v:f eqn="sum @10 21600 0"/>
 </v:formulas>
 <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
 <o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:142.5pt;
 height:53.25pt'>
 <v:imagedata src="e-mail%20signature_files/image001.gif" o:title=""/>
</v:shape><![endif]--><img
              src="cid:part1.04020508.04040903@subexworld.com"
              name="graphics1" width="190" align="BOTTOM" border="0"
              height="71"></font></font></p>
      <p style="margin-bottom: 0in;"><font color="#808080"><font
            face="Arial"><font style="font-size: 8pt;" size="1">Subex
              Limited, Adarsh Tech Park, Outer Ring Road,
              Devarabisannalli,
              Bangalore &#8211; 560037, India.<br>
            </font></font></font><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>Phone:</b></font></font></font><font
          color="#000000">
        </font><font color="#000000"><font face="Arial"><font
              style="font-size: 8pt;" size="1">+91
              80 6696 3371; </font></font></font><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>Mobile:</b></font></font></font><font
          color="#000000">
        </font><font color="#000000"><font face="Arial"><font
              style="font-size: 8pt;" size="1">+91
              9902065831</font></font></font><font color="#c1272d">&nbsp; </font><font
          color="#a01e55"><font face="Arial"><font style="font-size:
              8pt;" size="1"><b>Fax:</b></font></font></font><font
          color="#000000">
        </font><font color="#000000"><font face="Arial"><font
              style="font-size: 8pt;" size="1">+91
              80 6696 3333; </font></font></font>
      </p>
      <p style="margin-bottom: 0in;"><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>Email:</b></font></font></font><font
          color="#c1272d">
          &nbsp;</font><font color="#c1272d"><font face="Arial"><font
              style="font-size: 8pt;" size="1"><a
                href="mailto:email.id@subexworld.com">sivannarayanreddy@subexworld.com</a>;
            </font></font></font><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>URL:</b></font></font></font><font
          color="#c1272d">
          &nbsp;</font><a href="http://www.subexworld.com/"><font
            color="#c1272d"><font face="Arial"><font style="font-size:
                8pt;" size="1">www.subexworld.com</font></font></font></a><font
          color="#c1272d">
        </font>
      </p>
      <p style="margin-bottom: 0in;"><font color="#c1272d">&nbsp;</font></p>
      <p class="msonormal"><font color="#808080"><font face="Arial"><font
              style="font-size: 8pt;" size="1"><i>Disclaimer:
                This e-mail is bound by the terms and conditions
                described at
              </i></font></font></font><a
          href="http://www.subexworld.com/mail-disclaimer.html"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><i>http://www.subexworld.com/mail-disclaimer.html</i></font></font></a><font
          color="#808080"> <br>
        </font></p>
    </div>
  </body>
</html>

--------------090706030207000604070201
Content-Type: image/gif; name="graphics1"
Content-Transfer-Encoding: base64
Content-ID: <part1.04020508.04040903@subexworld.com>
Content-Disposition: inline; filename="graphics1"

R0lGODlhvgBHAHcAACH/C01TT0ZGSUNFOS4wDQAAAAFzUkdCAK7OHOkAIf8LTVNPRkZJQ0U5
LjAXAAAAC21zT1BNU09GRklDRTkuMEI8pPUALAAAAAC+AEcAh4ODg4uLi6KiotqpvP/BCf/T
U50aUPfs8P/IJe7Z4cuGosyJpfnw9P7yy/De5q9GcZwZTzY2Np4dU/71254eU3x8fLFKdf7c
d7Kystmmu2tra8nJyXV1df/ABfz8/Pz5+v/nnL5pjJUJQ6s9ar1miu3t7f/CDFtbW//RTPv1
+P/hiP/78ZqamsZ7mv7uuuHh4f/pqP78/dGVrsTExPny9f/DEqmpqdHR0f/77SwsLPHx8fXp
7uG6yvLh6KEmWKAgVb29vf/01UxMTNra2urO2VRUVKYyYv/MNM+QquXl5dyuwblehLm5ufXn
7f/NO7ZVfc2NqOnK196yxOK+zK1BbqUvX5oVTJsWTf/FG56ent3d3f++AJ4fWrtghv+/ApkS
SuTAz7RReZGRkbhagdfX1/r6+vr09/T09P37/Ojo6JsYTvz6+6g2ZRkZGfj4+Pb29uTB0N+0
xezU3v/9+dCQq6QtXpaWlv/5566urp4eUsmBn8HBwf/abKIoWs3NzUJCQiEhIdSbspkUS9Wd
tJwcUsR1lmRkZOXE0fPk6ufJ1f/rsMFxkqAkV5gQSJ8iVqMqXNCTtJ0cUMBukKQsXrlcgv7X
Yba2ttahtuvS3NejuKo4Z6YrS5wXTwgICPHg56AgVv/+++vQ2/7AA+3W4MN1lfTl654iVZwc
WrNRebBIcqQqXfry9tOYsOC3yJoSS+zT3ch+nP+9AMV4l/7YZtCSrJ8iVP/fgrNOd92ww5kV
TJ0dUr9sjv7337hZgObG1JcOR5gSSdSbs/+/A/ry9fjv85gRSZ8eVOS/z50bUZsaULVTe5kT
S50fVKQrXZ8hVf7////+/////p8gVaYuX/7+/58fVP7+/p4hVf/+/p8hVP7//p4gVPz4+Z4g
Vf79/frz9p8iVcJzk6YtX+/b47xROuWVHeSXIZ0gVf/1stF4OfPk79+2x5kXWLdXf//vwP/M
Abldib9ukf/71f76++ymL54hVOKZQ//HAJkVTf2+AP/LEf/HCNuswNurv6AhVv///wj/AP8J
HEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEmyJEhtJlNO/CADChI6MOlA
yRRDpc1/KG/qVMhA2q9iQIGKGMFtp8cY1IwqZUhjmgRn/qL6M5Dqw1KJ2KbIUCBLEoklS5T1
WtJlESwoYKxeXUqjylOpUx+ovWotWrR/dxN6oiCir9+/In4JjvRggYO1Rtu+lWpA7tW8Dg88
obKkkB4kmDErWHRrkg9CgtnE8Yb4pmKojB0jnuMwRtGEaA4k4KGHTTFkFsCUVnkabuO5SkFd
OHKBF0FoAyFHbBJuWaMRxAQi3y2yd2rgRoMQELYFwYUg/54J/7SrPOKaXcuWFZIObTp1j9aj
/l7boMYWAgS21LjgAsezZ9hcNI8sySCjxEDuvcdRfHFhtxM27lSChTD4eUEAAjD8lxEJjRhx
QHgkIVeeaW6hJp9qB4n3TIIWtQciQrzwYV8HBNBYQAMF2SVRP1fgk4GCITE4H3UT2OLEdiYI
YwIf4I03IkOJOLIMCQGG9IEDYPCTQSsOOJiSkCgO1MMhUmQgBRHfbIRGKVGsk8EAPLxyAGkF
geICCjSaIEoNs9xRkSePQGBEmh8NwwoVfVRjgBoU9PGAHuMcN9AaSrw5wKUDZKDEGgvJkQmm
l25Zk0BgztXEJb304QwyakTiCBskZP+QgkVEQGFBH45IoAajPjSjDCujCCSeQNjYUoMXJhAQ
ixMTjDesQ000Y8AjTXyUwQhXQEBBNT/8UA0FBiwzzQLV/lPlPzT4YAUE7LIriA80LASFCO2y
CwwVr6Fbom8PoPHPGrTUYQUneVQjTbfVSGCFIBbw4G9EDpCwzTIQGFMNt94ao6sgjFCCiUEN
FJCknhgK+yRCDvSBTDOldMSAJJxA4MzMcEkTlQRXGLFAQTSII0G3QBMyTbwKIVHMwUBDgKKQ
FqQQTCoQRGIzXDW3moovDA17zBiPXEEB1VQ7Iw0FV/RBSRwEiecOCqLg1wEKzUIUBSMrt7wR
N100Ik02M5v/GNUPUK1qhQIENSUB1bpMw8BCRvs9pL6LRYVbC8uo4QzfYEsljTPb5DKJbgxF
8cgXeUhFc9j+0MyMIBBIIZA22iAHDQhYdGBCd4pAJAUykbDMkQLL/JD58NVYAcVrhlMtwdCM
f+H40vtq/ogz1QxvvQE/rINXQS7+A4e0mV/Ttz/ig42MD7ggCKI7WNxHowoLdU+LIHnUEZ1G
ozByuPVgO3JFHZ4glVOUx7yiOY9fc2GQI6QxNf6BDRzIYATWnvUP5HhjAXQbntiMsS3MgY0Q
eYDFw/LyDF6oAAv4EUUl/HQygTCACsiAQBg8sJEMWCFzOLMC9qiGDFUcYiDJg8vy/4iWECQc
8DpAjF5UnHGNT9RMV5xQgwSqB7aZWeEW+ZLOPxKhBmT47W/hggAjEpULTlDRdM7QxRV+iBxr
COsfisDP7ZzQJINoKBOCcMYyYLG9jOgBGGG7wjR2IYkHqMGMqTMAOH4IxAEKsYBFPOKJEqhE
1KAGGcswABso0YUxaEICgtDFEk/nDEHI4CC7sAIpxdZFKuihH0QYxxRYsQRGWOFrcPEfCQZy
LoHAoH0m8AIC/ISQNaRCDdK4wo9aCBFsLEENNdNFCA7zD25kQhkSoAAywMEKnjlSKkNs3vMo
GTmqqWEEsojD/dA1BVlUwXKpc2JUdNGHYBEkA5E448woQP8IC/AjiwOJQhcYYYDT+eMHBrhE
QhqAAgIEswBxMwgrkCkBAKrpFgaAS6Psxksl5KEPcDBIEMEJSYQYcZxJLKdUrmABRCTEAe1Q
pd+cYYUx0OkfKUOGVD6RDWboIhCjShtBEsGGgpooEj6IFEKiUQn9iAIL7jCIAz7jD0GEoyNL
4ITppBGJfhwECTwYyLNGerOSflWSDUrpFx1hhQdwVDrPgAwDnnAFgzqDAoyw5z8WsAy/SWMZ
ejgINSj4DyL4oHRwWcbODBKNweIABfkwQQewYByCBMMKDFRDWFlkEVgIIpcSeAQSXNoQsvoj
nAZEKamUKDxkjCABDSkFGwgxU0H/0EIgZqBCQeFCiCoE0CGLuALVDEAFIh5kDhcwQZJQUNl/
YIINXoQAFjdyFyXscIn+0EUupqGH3yrEtKiNpGohZyKxGeBA0EjKQoAHtlzsQiChcAQz4NIN
NQwCIgnwgTFM1w1OHGghF9hCMBEAHk+wQWbMQEZYN4KccejPdKZwxA90IYg6ZOCmBwGvWQ1y
UgSqFS7MYARsqaFehYTCH/vFrhra4UYeSIAZJpKGI9rRhRrb+MY4rnEzzpg6VywWIQGaQwEE
7IUjTAAegnDEqvDFEfFYQxJ6m2nqIiFDtCFEw8Y963gZFAlNzIqwCImBBTKKXapYZQAQ2Bxc
nGEATrj5/81wjnMUZUw1K6yHIY8VhQneYY9TzBccXwgBSL7RAghsY3jduIIB2mHlCjZyfyTN
MofR+jgGWUESDxGPAr6gvBHMSgbLcKCorceJXWZtBSi4hzk2sT8J9CEUIpFFMeYLtmv4I5lq
WMTi3INlcXp4teUsBhQekpRMCFeIVYiX0UbNbHNSgrMGwcYz5EGPTZzictIQxGKhfRHkEOMJ
u6pi4KrRCEEXzmcElHRBOoxEYPutGLd1CHL6cd2yKpvTzc43BJQR1IS4UR0jMEA29gaBEXzI
XCHhBg8oAYxIOEPJX0ToLswwEG6MwIsanUS5iliM5+WLQcD4sUMGcUNkK7sYYP/bhgR0IYGW
u/zlMI95y60Qhn4nhAEWOLY/KOADIoxEQ/9IgQLqIAgKeBAu5P7xBx5ggAbu3HcKgQLK4aKG
J9zU0vGIiB7wDU5NUJwWrqCaNPowjSpM4+xoT7va1372PizB5pL6BwPG8FmpsIMcIBgPSJ5B
Dfd4Qg/++AIh+keISfRAIDG4BQRsLRUKPMK7CGmBIMoXlSt0oXCVbMzDHEIJaMIFGUy+LNWu
EAIz0OD0qE+96lefejMkBcwDmfsyGH9aQpRDHzjSBjMtAuZj7KKoflOybQdCgivIMyrG8IEc
FiKJKzjdCovAfDk/CvmFJKAPuFzivmtiXeFJxbWLIwn/N0jgPEekzhhcSMc+OuAEFtqkCajQ
+RKtYOp/UI72/mCGNECHEDSM2W9fMGwftkTboAYDkBwLAQuAtGaXJhBRAmOaY0oQAXQMkV7i
UQq9oHNiwwmQgA7KFQt88CIqkQBVoFNSkQ0r5kb/AGqpozmccIB2JB7j4AMUYCI/oAaZIH1+
JV1FwW0Vp1tgUwyE8w+IgH3llQyaEH4dMR2IkArL0EDOoAZUYBWzYCEIsAIhMQCnhBCDwAne
5w/ZsH0CEQdNt2ZXUH9C9Q+wgFmAExXVwAxYM4Cmgw8tgGEIsQBq8IVR4VMh9Q8eoAzyd2tq
4FUO0SUQ8QG9AAxqdjNXoFD//+AODiUMtsARkCEDPgABlOBzFdQ961Bv/iCG/7ADRiBKWxUJ
sjAX7oEEF8NDI6CE5AU20gABvfBWIogJXTBFYUN/N3UIFEBrSyQBk3A8OdJH//AKJNAHFtAC
SiWCBsEDFmCCqZMr4PAjAgEKfGAhJpA7jnYR0SAeMhBK5+AKRiAFGLYDFgABpnMNajAGJSYJ
eYRGq/MEr0AQKUAHVwBpUrEMLUCMDKI5X5AKU8ApBBEDUvAIguB0N+MIH0MQ6LFmabQMYbCM
BfENUPAIy0AByVAMRqAAvzVYBjEIOFMzzKAGwYCAOIAAHSAKV/gMOYERieBTM+MIMRQGlzAK
43AMt/8gf5cjCO81EFNgAPrkD0r2P+FABzLQAjC0DV/0CVbgVZDRj0t0DRCgC6mwAHFwCOsA
BWGQB7QFNp/wBXxUEA5Qgmi0QDnTAlLQA6d3AIcgAxaQC7rQN+AQCa4wDYEwKwaBC63iNz9Q
DLJgRyBgO16gAhRoEa2gCdAYFdJwSD7QB9JAZmhkBTk4EN5QCHX1RadlBV+wDIKAcWs2FZqw
A9v4iqYDDjUDAVZwOBJAMTzWgs5whnhZEHqplF8ESoSgCmYnDv6wLkJpOv4ADoLwAOUyHQkQ
Ag+GRsswBq44EKBQCRSCBRFlEaWgCkmWOZ9gDBZTRVJIKI62A1UQCdmQb1L/UQ0vOJqkGRUD
h5nSsIoaFAnMECwUZEEkAAyHljnSoDEt15pL9AO60oeOlgBG8AXZ9wnXUAuC0A7LSRAu4FBe
AAKwZx4KgA/Zx2w402j/oF6k8AsQmG/S0AjRZ54MYgrGkAzi+YkQUJLM6JFz1wgTKp7hQjjP
QgRUUFdUYwptJZoJcQco5AUF8KASsQCcgI8tmDm5IgFIgBClQAIGIKQOVDwhkKDnuXOakJMp
NmpqwAbUaEexpweOgI7i+QOcYARbKB7fQAt9YDnjAxVXwAawthAqoCQm4AIbMQiM4HypY1Dx
BBUGYDwLkQHVoAb1wETjM0p9kwxXUAgCKVJVEJfj/wMBFvANCqALBgBxtbY5eXAv1KQQ08ED
bFB0fIOnaDQzhPAFDyCR46AMxUAIpkmogpAKh8cQoOAEHcB+rOGjDaFeofAExSAIS3ox3vIt
yHAFgsAGMLgQA2AEgqBousAM+reezCABBnAFjaAJhFhihcMIxXAFVrCtVvALI1ATU8AGjXAF
yFAwF8NBrPIFPqAAH1KYBkFiArEDCuAD2YoMEmAx3HIxeUBlVlAMbCADq0AQ/TANV0B5oxSc
tHgQOgICyEIAcqp7GcENrEACFlAHjKAoxiANzTAC7YAEONoQO8AKXUAFRsAI0iAByCANjDAN
qdAFCkBa5jkQKUAKIbALNv9rsySgAA8zDgowsn1wWhIwdiPwBIWgie4qWARBBApAAlRQBT8r
ARBQDWPEBqgQAlAAs0RICl0EDngqDVZABQvpECtwBB0gDAUACsSYEWtwAKFwDErAA3BQCrEp
EdxAA3IAB1KgBGBABDvgJRfBDZ5wCK2wDnAwDilghxXBDQyQAFg5AFOQCJ7wDTYXA6xQB4gE
F+KTbSRwcBABA7ZTA+Cxe0AyuhUxHdyAHokZlczACaSQqBBxkrOaO6J7EbbaENMxHbXLe2+0
iR8BDbAXBcqgBtWAmf6ADMXQBdYKEdGAAtwBP7NLutDLEHkxCl3gD1pFpAZQB4MApQ9hCxZy
BFj/GL034QFlUBIosQYy0Ay3lDkzowZ1oIkW0QDK1QGKkLviaxBAAAQVIQAc0BBnkAUAIAYv
MBBDEAAVgAc0JBAbAAAawAIJjBfe0ALFEAnkg5nMkAvNYGU+2BBzQLZbwAf2WxLlSxAeQCcq
SBAnrAMFUb43cAMD4QGu6wFvYBB+IAY0FAAn4IcrXBBDAAhMgAF/4MIscAKWMAMAIAQqzL9A
cAN+8MBbpAtfM6jgxAwL8Krc+A8qQCPDtBRuwAFDfAID/A82UARFsAf/sAEBcMYAcMZi8A/e
UAF/wAFu8A9DvMZAsAFnHAAaUARaIBCWIAQnoAF4PBAa0AYnUAJ28Adw/6y//6AFJyAETEAQ
QxABAhEBTLAGOeAHA/EHM+ANOUAGCDEAnFCfo5Q6wSqAGzEBNVAj2mgUbmDIabDH/wAEOXAD
GAAIaaAFOSDGOeAGAtDGNmAHb6ABGPAPRQDG/2AHNvAPWfAHL2AHGvAPblDGaZADyzwQNnAC
SeABdtAGN8ACOVAGbiAEGEAGOZAEA6HLAgAAhlAGL5ADMywQB/zOZ4AQGaAGpHxr/tANgtAM
1BjCHOzBF7AUZ5ADePwCgOABGlABAiEELPAPf7AHY4wHAjAExgwAGFABy2wIliAQLIAHzPzQ
GyAE//ACafwPhnDNAsEE0fwPOPwPOtAGZzADOf+AAUBsxgKhBYBQAUWQBSWdA/UsEByAAfSM
EGBACA3kCDKpBiSwfJQoEBcQC7FQAASdAzPwDzeQA9agAS39B8ssBkUQACNdAeV7AjZQAmdA
GoYQyXQM0gJgB2dM0mnQv/9g1gRhCS390iUACGewAedcAmWQqJP8D3tdAh7wB2380wMsBIxs
ECnwAHW3QFagCvcVErxQALNQRzvhBoDwBxggBGuc1SzAAX9Qz1rQCWucAzn8DxhgCEDABCVQ
18X8D2KwzCzQxjPwB9bgAUXAAQIACCA9EBsQAfp7xITdCYAtBBqQvydszm/gycs8A4AQADYQ
AWv8DzPg0HuAAa77D3KyMALAsAzZ2gWwRRJHaxNnEAEG/NAC4QccAACx/Q/WYAcWbQNs/Q8C
UAEAkAasbdH/4AegfAN4nAQ24EZJEABZwNgEUQYGfMYg/QZiUM9nYMACcMIlwALliweMTAYA
UAGzvdIcUAEsgGHicQCBoAcKgAu9NBLPGxIF7cIl4QEsYAcAIMdAog0AbREtDhIeMAMqbBJ+
EAAs8OP3W+RGfuRI7hAnnORMXhpL3uRQHuVS/h4BAQA7
--------------090706030207000604070201--

--------------010503060009070302060100--



From pavel.stehule@gmail.com Wed Feb  16 12:50:35 2011
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 73E131337B6E
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 16 Feb 2011 08:50:35 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 81692-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 16 Feb 2011 12:50:28 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-iy0-f174.google.com (mail-iy0-f174.google.com
	[209.85.210.174])
	by mail.postgresql.org (Postfix) with ESMTP id A4DE7133616B
	for <pgsql-sql@postgresql.org>; Wed, 16 Feb 2011 08:50:27 -0400 (AST)
Received: by iyj8 with SMTP id 8so1176900iyj.19
	for <pgsql-sql@postgresql.org>; Wed, 16 Feb 2011 04:50:28 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:in-reply-to:references:from:date
	:message-id:subject:to:cc:content-type;
	bh=JCSac9dHKhvic4RmwQZRuhdzRHMXFeGu1qlz4l3RLtg=;
	b=QKQRN/EsXOw44kyCpyYshgYaoMYSXnJB3vDf9a/lD5nYyhx2tSbNxQniEAx6i8YlIA
	lbTCmk52Qcaw7IieiQCjdspcASbp2obtDRwAbtHOBxcMhdBC6zLz30Jh2kB0dZMX8k3C
	e8FJkLmU6kVF8GCsEayufNxL6cvNIv4V65pgw=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:from:date:message-id:subject:to
	:cc:content-type;
	b=Cjq2d4M61kSlrTAA2G0QapLwI9oMpiUEkajM2lWCVpHVjvAtt9B646HZsItm2D642K
	UhPERczRpzNMMWvH32OXASswhKpdJ7vcubfahmA6jCIUMHwpr3ogw5Z1OuKNB9ce4BIR
	Au5r1PfUiUmvlAq7ka0h6ktZb5CO9yE0ZtRpA=
Received: by 10.42.220.69 with SMTP id hx5mr717037icb.73.1297860627861; Wed,
	16 Feb 2011 04:50:27 -0800 (PST)
MIME-Version: 1.0
Received: by 10.42.163.6 with HTTP; Wed, 16 Feb 2011 04:49:47 -0800 (PST)
In-Reply-To: <4D5BC495.5000605@subexworld.com>
References: <4D5BC495.5000605@subexworld.com>
From: Pavel Stehule <pavel.stehule@gmail.com>
Date: Wed, 16 Feb 2011 13:49:47 +0100
Message-ID: <AANLkTi=vwg+0WYe5SZ5_4ZJj2fgnrk01WzENs0BW4ceF@mail.gmail.com>
Subject: Re: Function compile error
To: sivannarayanreddy@subexworld.com
Cc: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Content-Type: multipart/related; boundary=20cf30549ab1b11356049c65b903
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.588 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_LOW=-0.7,
	T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201102/80
X-Sequence-Number: 35156

--20cf30549ab1b11356049c65b903
Content-Type: multipart/alternative; boundary=20cf30549ab1b11351049c65b902

--20cf30549ab1b11351049c65b902
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello

please, look to page
http://www.postgresql.org/docs/9.0/interactive/plpgsql-porting.html

It can be faster, if you try to read PL/pgSQL documentation first. PL/pgSQL
is near PL/SQL, but it is a different language and environment still.

http://www.postgresql.org/docs/9.0/interactive/plpgsql.html

Regards

Pavel Stehule


2011/2/16 Sivannarayanreddy <sivannarayanreddy@subexworld.com>

>  Hello,
> I am trying to create the function as below but it is throwing error
> 'ERROR:  syntax error at or near "DECLARE"', Could some one help me pleas=
e
>
> CREATE FUNCTION check_password(databasename text, tablename text, indexna=
me
> text)RETURNS VOID AS
> DECLARE v_count INTEGER;
> BEGIN
>   select  count(1) into v_count  from  pg_index inx where  inx.indexrelid
> in
>  (select oid from pg_class where relname=3D$3 and relowner in
>  (select oid from pg_authid where rolname=3D$1))
>  and inx.indrelid in
>  (select oid from pg_class where relname=3D$2 and relowner in
>  (select oid from pg_authid where rolname=3D$1));
>  if v_count =3D 0 then
> execute immediate 'create unique index $3 on $2 (acn_id)';
> end if;
> END;
>
> *Sivannarayanareddy Nusum** **| **System Analyst(Moneta GDO)*
>
> Subex Limited, Adarsh Tech Park, Outer Ring Road, Devarabisannalli,
> Bangalore =E2=80=93 560037, India.
> *Phone:* +91 80 6696 3371; *Mobile:* +91 9902065831  *Fax:* +91 80 6696
> 3333;
>
> *Email:*  sivannarayanreddy@subexworld.com <email.id@subexworld.com>; *
> URL:*  www.subexworld.com
>
>
>
> *Disclaimer: This e-mail is bound by the terms and conditions described a=
t
> **http://www.subexworld.com/mail-disclaimer.html*<http://www.subexworld.c=
om/mail-disclaimer.html>
>

--20cf30549ab1b11351049c65b902
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hello<br><br>please, look to page <a href=3D"http://www.postgresql.org/docs=
/9.0/interactive/plpgsql-porting.html">http://www.postgresql.org/docs/9.0/i=
nteractive/plpgsql-porting.html</a><br><br>It can be faster, if you try to =
read PL/pgSQL documentation first. PL/pgSQL is near PL/SQL, but it is a dif=
ferent language and environment still.<br>

<br><a href=3D"http://www.postgresql.org/docs/9.0/interactive/plpgsql.html"=
>http://www.postgresql.org/docs/9.0/interactive/plpgsql.html</a><br><br>Reg=
ards<br><br>Pavel Stehule<br><br><br><div class=3D"gmail_quote">2011/2/16 S=
ivannarayanreddy <span dir=3D"ltr">&lt;<a href=3D"mailto:sivannarayanreddy@=
subexworld.com">sivannarayanreddy@subexworld.com</a>&gt;</span><br>

<blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; borde=
r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">

 =20

   =20
 =20
  <div text=3D"#000099" bgcolor=3D"#ffffff">
    <tt>Hello,<br>
      I am trying to create the function as below but it is throwing
      error &#39;ERROR:=C2=A0 syntax error at or near &quot;DECLARE&quot;&#=
39;, Could some one
      help me please<br>
      <br>
      CREATE FUNCTION check_password(databasename text, tablename text,
      indexname text)RETURNS VOID AS <br>
      DECLARE v_count INTEGER;<br>
      BEGIN<br>
      =C2=A0 select=C2=A0 count(1) into v_count=C2=A0 from=C2=A0 pg_index i=
nx where=C2=A0
      inx.indexrelid in<br>
      =C2=A0(select oid from pg_class where relname=3D$3 and relowner in <b=
r>
      =C2=A0(select oid from pg_authid where rolname=3D$1)) <br>
      =C2=A0and inx.indrelid in <br>
      =C2=A0(select oid from pg_class where relname=3D$2 and relowner in <b=
r>
      =C2=A0(select oid from pg_authid where rolname=3D$1)); <br>
      =C2=A0if v_count =3D 0 then=C2=A0 <br>
      execute immediate &#39;create unique index $3 on $2 (acn_id)&#39;;=C2=
=A0 <br>
      end if; <br>
      END;</tt><br>
    <div><br>
     =20
     =20
     =20
     =20
     =20
     =20
     =20
     =20
     =20
     =20
     =20
     =20
     =20
     =20
     =20
     =20
      <p style=3D"margin-bottom: 0in;"><b><font color=3D"#939598"><font fac=
e=3D"Arial"><font size=3D"2">Sivannarayanareddy
                Nusum</font></font></font></b><b><font color=3D"#000080"> <=
/font></b><b><font color=3D"#000080"><font face=3D"Arial"><font size=3D"2">=
|
              </font></font></font></b><b><font color=3D"#0000ff"><font fac=
e=3D"Arial"><font size=3D"2">System
                Analyst(Moneta GDO)</font></font></font></b><font color=3D"=
#000080">
        </font>
      </p>
      <p style=3D"margin-bottom: 0in;"><font face=3D"Arial"><font style=3D"=
font-size: 8pt;" size=3D"1"><img src=3D"cid:part1.04020508.04040903@subexwo=
rld.com" name=3D"graphics1" height=3D"71" width=3D"190" align=3D"BOTTOM" bo=
rder=3D"0"></font></font></p>


      <p style=3D"margin-bottom: 0in;"><font color=3D"#808080"><font face=
=3D"Arial"><font style=3D"font-size: 8pt;" size=3D"1">Subex
              Limited, Adarsh Tech Park, Outer Ring Road,
              Devarabisannalli,
              Bangalore =E2=80=93 560037, India.<br>
            </font></font></font><font color=3D"#a01e55"><font face=3D"Aria=
l"><font style=3D"font-size: 8pt;" size=3D"1"><b>Phone:</b></font></font></=
font><font color=3D"#000000">
        </font><font color=3D"#000000"><font face=3D"Arial"><font style=3D"=
font-size: 8pt;" size=3D"1">+91
              80 6696 3371; </font></font></font><font color=3D"#a01e55"><f=
ont face=3D"Arial"><font style=3D"font-size: 8pt;" size=3D"1"><b>Mobile:</b=
></font></font></font><font color=3D"#000000">
        </font><font color=3D"#000000"><font face=3D"Arial"><font style=3D"=
font-size: 8pt;" size=3D"1">+91
              9902065831</font></font></font><font color=3D"#c1272d">=C2=A0=
 </font><font color=3D"#a01e55"><font face=3D"Arial"><font style=3D"font-si=
ze: 8pt;" size=3D"1"><b>Fax:</b></font></font></font><font color=3D"#000000=
">
        </font><font color=3D"#000000"><font face=3D"Arial"><font style=3D"=
font-size: 8pt;" size=3D"1">+91
              80 6696 3333; </font></font></font>
      </p>
      <p style=3D"margin-bottom: 0in;"><font color=3D"#a01e55"><font face=
=3D"Arial"><font style=3D"font-size: 8pt;" size=3D"1"><b>Email:</b></font><=
/font></font><font color=3D"#c1272d">
          =C2=A0</font><font color=3D"#c1272d"><font face=3D"Arial"><font s=
tyle=3D"font-size: 8pt;" size=3D"1"><a href=3D"mailto:email.id@subexworld.c=
om" target=3D"_blank">sivannarayanreddy@subexworld.com</a>;
            </font></font></font><font color=3D"#a01e55"><font face=3D"Aria=
l"><font style=3D"font-size: 8pt;" size=3D"1"><b>URL:</b></font></font></fo=
nt><font color=3D"#c1272d">
          =C2=A0</font><a href=3D"http://www.subexworld.com/" target=3D"_bl=
ank"><font color=3D"#c1272d"><font face=3D"Arial"><font style=3D"font-size:=
 8pt;" size=3D"1">www.subexworld.com</font></font></font></a><font color=3D=
"#c1272d">
        </font>
      </p>
      <p style=3D"margin-bottom: 0in;"><font color=3D"#c1272d">=C2=A0</font=
></p>
      <p><font color=3D"#808080"><font face=3D"Arial"><font style=3D"font-s=
ize: 8pt;" size=3D"1"><i>Disclaimer:
                This e-mail is bound by the terms and conditions
                described at
              </i></font></font></font><a href=3D"http://www.subexworld.com=
/mail-disclaimer.html" target=3D"_blank"><font face=3D"Arial"><font style=
=3D"font-size: 8pt;" size=3D"1"><i>http://www.subexworld.com/mail-disclaime=
r.html</i></font></font></a><font color=3D"#808080"> <br>


        </font></p>
    </div>
  </div>

</blockquote></div><br>

--20cf30549ab1b11351049c65b902--

--20cf30549ab1b11356049c65b903
Content-Type: image/gif; name=graphics1
Content-Transfer-Encoding: base64
Content-ID: <part1.04020508.04040903@subexworld.com>
X-Attachment-Id: 396320ba411db1e2_0.1.1

R0lGODlhvgBHAHcAACH/C01TT0ZGSUNFOS4wDQAAAAFzUkdCAK7OHOkAIf8LTVNPRkZJQ0U5LjAX
AAAAC21zT1BNU09GRklDRTkuMEI8pPUALAAAAAC+AEcAh4ODg4uLi6KiotqpvP/BCf/TU50aUPfs
8P/IJe7Z4cuGosyJpfnw9P7yy/De5q9GcZwZTzY2Np4dU/71254eU3x8fLFKdf7cd7Kystmmu2tr
a8nJyXV1df/ABfz8/Pz5+v/nnL5pjJUJQ6s9ar1miu3t7f/CDFtbW//RTPv1+P/hiP/78ZqamsZ7
mv7uuuHh4f/pqP78/dGVrsTExPny9f/DEqmpqdHR0f/77SwsLPHx8fXp7uG6yvLh6KEmWKAgVb29
vf/01UxMTNra2urO2VRUVKYyYv/MNM+QquXl5dyuwblehLm5ufXn7f/NO7ZVfc2NqOnK196yxOK+
zK1BbqUvX5oVTJsWTf/FG56ent3d3f++AJ4fWrtghv+/ApkSSuTAz7RReZGRkbhagdfX1/r6+vr0
9/T09P37/Ojo6JsYTvz6+6g2ZRkZGfj4+Pb29uTB0N+0xezU3v/9+dCQq6QtXpaWlv/5566urp4e
UsmBn8HBwf/abKIoWs3NzUJCQiEhIdSbspkUS9WdtJwcUsR1lmRkZOXE0fPk6ufJ1f/rsMFxkqAk
V5gQSJ8iVqMqXNCTtJ0cUMBukKQsXrlcgv7XYba2ttahtuvS3NejuKo4Z6YrS5wXTwgICPHg56Ag
Vv/+++vQ2/7AA+3W4MN1lfTl654iVZwcWrNRebBIcqQqXfry9tOYsOC3yJoSS+zT3ch+nP+9AMV4
l/7YZtCSrJ8iVP/fgrNOd92ww5kVTJ0dUr9sjv7337hZgObG1JcOR5gSSdSbs/+/A/ry9fjv85gR
SZ8eVOS/z50bUZsaULVTe5kTS50fVKQrXZ8hVf7////+/////p8gVaYuX/7+/58fVP7+/p4hVf/+
/p8hVP7//p4gVPz4+Z4gVf79/frz9p8iVcJzk6YtX+/b47xROuWVHeSXIZ0gVf/1stF4OfPk79+2
x5kXWLdXf//vwP/MAbldib9ukf/71f76++ymL54hVOKZQ//HAJkVTf2+AP/LEf/HCNuswNurv6Ah
Vv///wj/AP8JHEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEmyJEhtJlNO/CAD
ChI6MOlAyRRDpc1/KG/qVMhA2q9iQIGKGMFtp8cY1IwqZUhjmgRn/qL6M5Dqw1KJ2KbIUCBLEokl
S5T1WtJlESwoYKxeXUqjylOpUx+ovWotWrR/dxN6oiCir9+/In4JjvRggYO1Rtu+lWpA7tW8Dg88
obKkkB4kmDErWHRrkg9CgtnE8Yb4pmKojB0jnuMwRtGEaA4k4KGHTTFkFsCUVnkabuO5SkFdOHKB
F0FoAyFHbBJuWaMRxAQi3y2yd2rgRoMQELYFwYUg/54J/7SrPOKaXcuWFZIObTp1j9aj/l7boMYW
AgS21LjgAsezZ9hcNI8sySCjxEDuvcdRfHFhtxM27lSChTD4eUEAAjD8lxEJjRhxQHgkIVeeaW6h
Jp9qB4n3TIIWtQciQrzwYV8HBNBYQAMF2SVRP1fgk4GCITE4H3UT2OLEdiYIYwIf4I03IkOJOLIM
CQGG9IEDYPCTQSsOOJiSkCgO1MMhUmQgBRHfbIRGKVGsk8EAPLxyAGkFgeICCjSaIEoNs9xRkSeP
QGBEmh8NwwoVfVRjgBoU9PGAHuMcN9AaSrw5wKUDZKDEGgvJkQmml25Zk0BgztXEJb304QwyakTi
CBskZP+QgkVEQGFBH45IoAajPjSjDCujCCSeQNjYUoMXJhAQixMTjDesQ000Y8AjTXyUwQhXQEBB
NT/8UA0FBiwzzQLV/lPlPzT4YAUE7LIriA80LASFCO2yCwwVr6Fbom8PoPHPGrTUYQUneVQjTbfV
SGCFIBbw4G9EDpCwzTIQGFMNt94ao6sgjFCCiUENFJCknhgK+yRCDvSBTDOldMSAJJxA4MzMcEkT
lQRXGLFAQTSII0G3QBMyTbwKIVHMwUBDgKKQFqQQTCoQRGIzXDW3moovDA17zBiPXEEB1VQ7Iw0F
V/RBSRwEiecOCqLg1wEKzUIUBSMrt7wRN100Ik02M5v/GNUPUK1qhQIENSUB1bpMw8BCRvs9pL6L
RYVbC8uo4QzfYEsljTPb5DKJbgxF8cgXeUhFc9j+0MyMIBBIIZA22iAHDQhYdGBCd4pAJAUykbDM
kQLL/JD58NVYAcVrhlMtwdCMf+H40vtq/ogz1QxvvQE/rINXQS7+A4e0mV/Ttz/ig42MD7ggCKI7
WNxHowoLdU+LIHnUEZ1GozByuPVgO3JFHZ4glVOUx7yiOY9fc2GQI6QxNf6BDRzIYATWnvUP5Hhj
AXQbntiMsS3MgY0QeYDFw/LyDF6oAAv4EUUl/HQygTCACsiAQBg8sJEMWCFzOLMC9qiGDFUcYiDJ
g8vy/4iWECQc8DpAjF5UnHGNT9RMV5xQgwSqB7aZWeEW+ZLOPxKhBmT47W/hggAjEpULTlDRdM7Q
xRV+iBxrCOsfisDP7ZzQJINoKBOCcMYyYLG9jOgBGGG7wjR2IYkHqMGMqTMAOH4IxAEKsYBFPOKJ
EqhE1KAGGcswABso0YUxaEICgtDFEk/nDEHI4CC7sAIpxdZFKuihH0QYxxRYsQRGWOFrcPEfCQZy
LoHAoH0m8AIC/ISQNaRCDdK4wo9aCBFsLEENNdNFCA7zD25kQhkSoAAywMEKnjlSKkNs3vMoGTmq
qWEEsojD/dA1BVlUwXKpc2JUdNGHYBEkA5E448woQP8IC/AjiwOJQhcYYYDT+eMHBrhEQhqAAgIE
swBxMwgrkCkBAKrpFgaAS6Psxksl5KEPcDBIEMEJSYQYcZxJLKdUrmABRCTEAe1Qpd+cYYUx0Okf
KUOGVD6RDWboIhCjShtBEsGGgpooEj6IFEKiUQn9iAIL7jCIAz7jD0GEoyNL4ITppBGJfhwECTwY
yLNGerOSflWSDUrpFx1hhQdwVDrPgAwDnnAFgzqDAoyw5z8WsAy/SWMZejgINSj4DyL4oHRwWcbO
DBKNweIABfkwQQewYByCBMMKDFRDWFlkEVgIIpcSeAQSXNoQsvojnAZEKamUKDxkjCABDSkFGwgx
U0H/0EIgZqBCQeFCiCoE0CGLuALVDEAFIh5kDhcwQZJQUNl/YIINXoQAFjdyFyXscIn+0EUupqGH
3yrEtKiNpGohZyKxGeBA0EjKQoAHtlzsQiChcAQz4NINNQwCIgnwgTFM1w1OHGghF9hCMBEAHk+w
QWbMQEZYN4KccejPdKZwxA90IYg6ZOCmBwGvWQ1yUgSqFS7MYARsqaFehYTCH/vFrhra4UYeSIAZ
JpKGI9rRhRrb+MY4rnEzzpg6VywWIQGaQwEE7IUjTAAegnDEqvDFEfFYQxJ6m2nqIiFDtCFEw8Y9
63gZFAlNzIqwCImBBTKKXapYZQAQ2BxcnGEATrj5/81wjnMUZUw1K6yHIY8VhQneYY9TzBccXwgB
SL7RAghsY3jduIIB2mHlCjZyfyTNMofR+jgGWUESDxGPAr6gvBHMSgbLcKCorceJXWZtBSi4hzk2
sT8J9CEUIpFFMeYLtmv4I5lqWMTi3INlcXp4teUsBhQekpRMCFeIVYiX0UbNbHNSgrMGwcYz5EGP
TZzictIQxGKhfRHkEOMJu6pi4KrRCEEXzmcElHRBOoxEYPutGLd1CHL6cd2yKpvTzc43BJQR1IS4
UR0jMEA29gaBEXzIXCHhBg8oAYxIOEPJX0ToLswwEG6MwIsanUS5iliM5+WLQcD4sUMGcUNkK7sY
YP/bhgR0IYGWu/zlMI95y60Qhn4nhAEWOLY/KOADIoxEQ/9IgQLqIAgKeBAu5P7xBx5ggAbu3HcK
gQLK4aKGJ9zU0vGIiB7wDU5NUJwWrqCaNPowjSpM4+xoT7va1372PizB5pL6BwPG8FmpsIMcIBgP
SJ5BDfd4Qg/++AIh+keISfRAIDG4BQRsLRUKPMK7CGmBIMoXlSt0oXCVbMzDHEIJaMIFGUy+LNWu
EAIz0OD0qE+96lefejMkBcwDmfsyGH9aQpRDHzjSBjMtAuZj7KKoflOybQdCgivIMyrG8IEcFiKJ
KzjdCovAfDk/CvmFJKAPuFzivmtiXeFJxbWLIwn/N0jgPEekzhhcSMc+OuAEFtqkCajQ+RKtYOp/
UI72/mCGNECHEDSM2W9fMGwftkTboAYDkBwLAQuAtGaXJhBRAmOaY0oQAXQMkV7iUQq9oHNiwwmQ
gA7KFQt88CIqkQBVoFNSkQ0r5kb/AGqpozmccIB2JB7j4AMUYCI/oAaZIH1+JV1FwW0Vp1tgUwyE
8w+IgH3llQyaEH4dMR2IkArL0EDOoAZUYBWzYCEIsAIhMQCnhBCDwAne5w/ZsH0CEQdNt2ZXUH9C
9Q+wgFmAExXVwAxYM4Cmgw8tgGEIsQBq8IVR4VMh9Q8eoAzyd2tq4FUO0SUQ8QG9AAxqdjNXoFD/
/+AODiUMtsARkCEDPgABlOBzFdQ961Bv/iCG/7ADRiBKWxUJsjAX7oEEF8NDI6CE5AU20gABvfBW
IogJXTBFYUN/N3UIFEBrSyQBk3A8OdJH//AKJNAHFtACSiWCBsEDFmCCqZMr4PAjAgEKfGAhJpA7
jnYR0SAeMhBK5+AKRiAFGLYDFgABpnMNajAGJSYJeYRGq/MEr0AQKUAHVwBpUrEMLUCMDKI5X5AK
U8ApBBEDUvAIguB0N+MIH0MQ6LFmabQMYbCMBfENUPAIy0AByVAMRqAAvzVYBjEIOFMzzKAGwYCA
OIAAHSAKV/gMOYERieBTM+MIMRQGlzAK43AMt/8gf5cjCO81EFNgAPrkD0r2P+FABzLQAjC0DV/0
CVbgVZDRj0t0DRCgC6mwAHFwCOsABWGQB7QFNp/wBXxUEA5Qgmi0QDnTAlLQA6d3AIcgAxaQC7rQ
N+AQCa4wDYEwKwaBC63iNz9QDLJgRyBgO16gAhRoEa2gCdAYFdJwSD7QB9JAZmhkBTk4EN5QCHX1
RadlBV+wDIKAcWs2FZqwA9v4iqYDDjUDAVZwOBJAMTzWgs5whnhZEHqplF8ESoSgCmYnDv6wLkJp
Ov4ADoLwAOUyHQkQAg+GRsswBq44EKBQCRSCBRFlEaWgCkmWOZ9gDBZTRVJIKI62A1UQCdmQb1L/
UQ0vOJqkGRUDh5nSsIoaFAnMECwUZEEkAAyHljnSoDEt15pL9AO60oeOlgBG8AXZ9wnXUAuC0A7L
SRAu4FBeAAKwZx4KgA/Zx2w402j/oF6k8AsQmG/S0AjRZ54MYgrGkAzi+YkQUJLM6JFz1wgTKp7h
QjjPQgRUUFdUYwptJZoJcQco5AUF8KASsQCcgI8tmDm5IgFIgBClQAIGIKQOVDwhkKDnuXOakJMp
NmpqwAbUaEexpweOgI7i+QOcYARbKB7fQAt9YDnjAxVXwAawthAqoCQm4AIbMQiM4HypY1DxBBUG
YDwLkQHVoAb1wETjM0p9kwxXUAgCKVJVEJfj/wMBFvANCqALBgBxtbY5eXAv1KQQ08EDbFB0fIOn
aDQzhPAFDyCR46AMxUAIpkmogpAKh8cQoOAEHcB+rOGjDaFeofAExSAIS3ox3vItyHAFgsAGMLgQ
A2AEgqBousAM+reezCABBnAFjaAJhFhihcMIxXAFVrCtVvALI1ATU8AGjXAFyFAwF8NBrPIFPqAA
H1KYBkFiArEDCuAD2YoMEmAx3HIxeUBlVlAMbCADq0AQ/TANV0B5oxSctHgQOgICyEIAcqp7GcEN
rEACFlAHjKAoxiANzTAC7YAEONoQO8AKXUAFRsAI0iAByCANjDANqdAFCkBa5jkQKUAKIbALNv9r
sySgAA8zDgowsn1wWhIwdiPwBIWgie4qWARBBApAAlRQBT8rARBQDWPEBqgQAlAAs0RICl0EDngq
DVZABQvpECtwBB0gDAUACsSYEWtwAKFwDErAA3BQCrEpEdxAA3IAB1KgBGBABDvgJRfBDZ5wCK2w
DnAwDilghxXBDQyQAFg5AFOQCJ7wDTYXA6xQB4gEF+KTbSRwcBABA7ZTA+Cxe0AyuhUxHdyAHokZ
lczACaSQqBBxkrOaO6J7EbbaENMxHbXLe2+0iR8BDbAXBcqgBtWAmf6ADMXQBdYKEdGAAtwBP7NL
utDLEHkxCl3gD1pFpAZQB4MApQ9hCxZyBFj/GL034QFlUBIosQYy0Ay3lDkzowZ1oIkW0QDK1QGK
kLviaxBAAAQVIQAc0BBnkAUAIAYvMBBDEAAVgAc0JBAbAAAawAIJjBfe0ALFEAnkg5nMkAvNYGU+
2BBzQLZbwAf2WxLlSxAeQCcqSBAnrAMFUb43cAMD4QGu6wFvYBB+IAY0FAAn4IcrXBBDAAhMgAF/
4MIscAKWMAMAIAQqzL9AcAN+8MBbpAtfM6jgxAwL8Krc+A8qQCPDtBRuwAFDfAID/A82UARFsAf/
sAEBcMYAcMZi8A/eUAF/wAFu8A9DvMZAsAFnHAAaUARaIBCWIAQnoAF4PBAa0AYnUAJ28Adw/6y/
/6AFJyAETEAQQxABAhEBTLAGOeAHA/EHM+ANOUAGCDEAnFCfo5Q6wSqAGzEBNVAj2mgUbmDIabDH
/wAEOXADGAAIaaAFOSDGOeAGAtDGNmAHb6ABGPAPRQDG/2AHNvAPWfAHL2AHGvAPblDGaZADyzwQ
NnACSeABdtAGN8ACOVAGbiAEGEAGOZAEA6HLAgAAhlAGL5ADMywQB/zOZ4AQGaAGpHxr/tANgtAM
1BjCHOzBF7AUZ5ADePwCgOABGlABAiEELPAPf7AHY4wHAjAExgwAGFABy2wIliAQLIAHzPzQGyAE
//ACafwPhnDNAsEE0fwPOPwPOtAGZzADOf+AAUBsxgKhBYBQAUWQBSWdA/UsEByAAfSMEGBACA3k
CDKpBiSwfJQoEBcQC7FQAASdAzPwDzeQA9agAS39B8ssBkUQACNdAeV7AjZQAmdAGoYQyXQM0gJg
B2dM0mnQv/9g1gRhCS390iUACGewAedcAmWQqJP8D3tdAh7wB2380wMsBIxsECnwAHW3QFagCvcV
ErxQALNQRzvhBoDwBxggBGuc1SzAAX9Qz1rQCWucAzn8DxhgCEDABCVQ18X8D2KwzCzQxjPwB9bg
AUXAAQIACCA9EBsQAfp7xITdCYAtBBqQvydszm/gycs8A4AQADYQAWv8DzPg0HuAAa77D3KyMALA
sAzZ2gWwRRJHaxNnEAEG/NAC4QccAACx/Q/WYAcWbQNs/Q8CUAEAkAasbdH/4AegfAN4nAQ24EZJ
EABZwNgEUQYGfMYg/QZiUM9nYMACcMIlwALliweMTAYAUAGzvdIcUAEsgGHicQCBoAcKgAu9NBLP
GxIF7cIl4QEsYAcAIMdAog0AbREtDhIeMAMqbBJ+EAAs8OP3W+RGfuRI7hAnnORMXhpL3uRQHuVS
/h4BAQA7
--20cf30549ab1b11356049c65b903--



From ineyman@perceptron.com Wed Feb  16 16:37:12 2011
Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 439031337B8C
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 16 Feb 2011 12:37:12 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 52228-04-4 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Wed, 16 Feb 2011 16:37:04 +0000 (UTC)
X-Greylist: delayed 00:12:10.700228 by SQLgrey-1.7.6
Received: from EXCHANGE.perceptron.com (exchange.perceptron.com
 [68.22.13.203])
	by mail.postgresql.org (Postfix) with ESMTP id 8FA691337B7E
	for <pgsql-sql@postgresql.org>; Wed, 16 Feb 2011 12:37:04 -0400 (AST)
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: Re: Function compile error
Date: Wed, 16 Feb 2011 11:24:51 -0500
Message-ID: 
 <F4C27E77F7A33E4CA98C19A9DC6722A207221F44@EXCHANGE.corp.perceptron.com>
In-Reply-To: <4D5BC495.5000605@subexworld.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Function compile error
Thread-Index: AcvN9gk5OqyCzWu0QESjvMjNvVuPfA==
References: <4D5BC495.5000605@subexworld.com>
From: "Igor Neyman" <ineyman@perceptron.com>
To: <sivannarayanreddy@subexworld.com>,
	<pgsql-sql@postgresql.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201102/83
X-Sequence-Number: 35159

=20

> -----Original Message-----
> From: Sivannarayanreddy [mailto:sivannarayanreddy@subexworld.com]=20
> Sent: Wednesday, February 16, 2011 7:36 AM
> To: pgsql-sql@postgresql.org
> Subject: Function compile error
>=20
> Hello,
> I am trying to create the function as below but it is=20
> throwing error 'ERROR:  syntax error at or near "DECLARE"',=20
> Could some one help me please
>=20
> CREATE FUNCTION check_password(databasename text, tablename=20
> text, indexname text)RETURNS VOID AS=20
> DECLARE v_count INTEGER;
> BEGIN
>   select  count(1) into v_count  from  pg_index inx where =20
> inx.indexrelid in
>  (select oid from pg_class where relname=3D$3 and relowner in=20
>  (select oid from pg_authid where rolname=3D$1))=20
>  and inx.indrelid in=20
>  (select oid from pg_class where relname=3D$2 and relowner in=20
>  (select oid from pg_authid where rolname=3D$1));=20
>  if v_count =3D 0 then =20
> execute immediate 'create unique index $3 on $2 (acn_id)'; =20
> end if;=20
> END;
>=20
>=20
>=20
> Sivannarayanareddy Nusum | System Analyst(Moneta GDO)=20
>=20
>=20
>=20
> Subex Limited, Adarsh Tech Park, Outer Ring Road,=20
> Devarabisannalli, Bangalore - 560037, India.
> Phone: +91 80 6696 3371; Mobile: +91 9902065831  Fax: +91 80=20
> 6696 3333;=20
>=20
> Email:  sivannarayanreddy@subexworld.com=20
> <mailto:email.id@subexworld.com> ; URL:  www.subexworld.com=20
> <http://www.subexworld.com/> =20
>=20
> =20
>=20
> Disclaimer: This e-mail is bound by the terms and conditions=20
> described at http://www.subexworld.com/mail-disclaimer.html=20
> <http://www.subexworld.com/mail-disclaimer.html> =20
>=20



CREATE FUNCTION check_password(databasename text, tablename text,
indexname text)
RETURNS VOID AS $body$
DECLARE v_count INTEGER;
BEGIN
  select  count(1) into v_count  from  pg_index inx where
inx.indexrelid in
 (select oid from pg_class where relname=3D$3 and relowner in=20
 (select oid from pg_authid where rolname=3D$1))=20
 and inx.indrelid in=20
 (select oid from pg_class where relname=3D$2 and relowner in=20
 (select oid from pg_authid where rolname=3D$1));=20
 if v_count =3D 0 then =20
execute immediate 'create unique index $3 on $2 (acn_id)'; =20
end if;=20
END;
$body$LANGUAGE PLPGSQL;

Regards,
Igor Neyman



From sivannarayanreddy@subexworld.com Fri Feb  18 05:43:41 2011
Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 9A18D1337B4F
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 18 Feb 2011 01:43:41 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 11502-07 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Fri, 18 Feb 2011 05:43:32 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from cx296.800onemail.com (CX296.800onemail.com [209.171.54.154])
	by mail.postgresql.org (Postfix) with ESMTP id E08511337B4A
	for <pgsql-sql@postgresql.org>; Fri, 18 Feb 2011 01:43:31 -0400 (AST)
Received: from EX13-N05.exchserver.com ([10.7.5.66])
	by cx296.800onemail.com (8.13.8/8.13.8) with ESMTP id p1I5hFGu002822
	for <pgsql-sql@postgresql.org>; Fri, 18 Feb 2011 00:43:15 -0500
Received: from EX60.exchserver.com (10.7.5.154) by EX13-N05.exchserver.com
	(10.7.40.162) with Microsoft SMTP Server id 8.3.106.1; Fri, 18 Feb 2011
	00:43:15 -0500
Received: from [127.0.0.1] ([164.164.82.29]) by EX60.exchserver.com with
	Microsoft SMTPSVC(6.0.3790.3959);	 Fri, 18 Feb 2011 00:43:13 -0500
Message-ID: <4D5E0755.2080304@subexworld.com>
Date: Fri, 18 Feb 2011 11:14:53 +0530
From: Sivannarayanreddy <sivannarayanreddy@subexworld.com>
Reply-To: sivannarayanreddy@subexworld.com
Organization: Subex Ltd.
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7
MIME-Version: 1.0
To: Igor Neyman <ineyman@perceptron.com>
CC: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: Function compile error
References: <4D5BC495.5000605@subexworld.com>
	<F4C27E77F7A33E4CA98C19A9DC6722A207221F44@EXCHANGE.corp.perceptron.com>
In-Reply-To: 
 <F4C27E77F7A33E4CA98C19A9DC6722A207221F44@EXCHANGE.corp.perceptron.com>
Content-Type: multipart/alternative;
	boundary="------------030806020603090301020501"
X-OriginalArrivalTime: 18 Feb 2011 05:43:13.0968 (UTC)
	FILETIME=[BBFEE300:01CBCF2E]
X-EXCLAIMER-MD-CONFIG: 82961a98-cce1-4d12-bc86-b4f9bd03ebf6
X-Crx-NoRoute: SMTP reroute not required
X-CRXEFW-Info: Please contact Ceryx for more information
X-CRXEFW-Virus: Clean
X-CRXEFW-From: sivannarayanreddy@subexworld.com
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.899 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201102/94
X-Sequence-Number: 35170

--------------030806020603090301020501
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit

Thanks Igor Nayman!!! The function worked for me

*Sivannarayanareddy Nusum****| **System Analyst(Moneta GDO)*

Subex Limited, Adarsh Tech Park, Outer Ring Road, Devarabisannalli, 
Bangalore -- 560037, India.
*Phone:*+91 80 6696 3371; *Mobile:*+91 9902065831*Fax:*+91 80 6696 3333;

*Email:*sivannarayanreddy@subexworld.com 
<mailto:email.id@subexworld.com>; *URL:*www.subexworld.com 
<http://www.subexworld.com/>

/Disclaimer: This e-mail is bound by the terms and conditions described 
at //http://www.subexworld.com/mail-disclaimer.html/


On 2/16/2011 9:54 PM, Igor Neyman wrote:
>
>
>> -----Original Message-----
>> From: Sivannarayanreddy [mailto:sivannarayanreddy@subexworld.com]
>> Sent: Wednesday, February 16, 2011 7:36 AM
>> To: pgsql-sql@postgresql.org
>> Subject: Function compile error
>>
>> Hello,
>> I am trying to create the function as below but it is
>> throwing error 'ERROR:  syntax error at or near "DECLARE"',
>> Could some one help me please
>>
>> CREATE FUNCTION check_password(databasename text, tablename
>> text, indexname text)RETURNS VOID AS
>> DECLARE v_count INTEGER;
>> BEGIN
>>    select  count(1) into v_count  from  pg_index inx where
>> inx.indexrelid in
>>   (select oid from pg_class where relname=$3 and relowner in
>>   (select oid from pg_authid where rolname=$1))
>>   and inx.indrelid in
>>   (select oid from pg_class where relname=$2 and relowner in
>>   (select oid from pg_authid where rolname=$1));
>>   if v_count = 0 then
>> execute immediate 'create unique index $3 on $2 (acn_id)';
>> end if;
>> END;
>>
>>
>>
>> Sivannarayanareddy Nusum | System Analyst(Moneta GDO)
>>
>>
>>
>> Subex Limited, Adarsh Tech Park, Outer Ring Road,
>> Devarabisannalli, Bangalore - 560037, India.
>> Phone: +91 80 6696 3371; Mobile: +91 9902065831  Fax: +91 80
>> 6696 3333;
>>
>> Email:  sivannarayanreddy@subexworld.com
>> <mailto:email.id@subexworld.com>  ; URL:  www.subexworld.com
>> <http://www.subexworld.com/>
>>
>>
>>
>> Disclaimer: This e-mail is bound by the terms and conditions
>> described at http://www.subexworld.com/mail-disclaimer.html
>> <http://www.subexworld.com/mail-disclaimer.html>
>>
>
>
> CREATE FUNCTION check_password(databasename text, tablename text,
> indexname text)
> RETURNS VOID AS $body$
> DECLARE v_count INTEGER;
> BEGIN
>    select  count(1) into v_count  from  pg_index inx where
> inx.indexrelid in
>   (select oid from pg_class where relname=$3 and relowner in
>   (select oid from pg_authid where rolname=$1))
>   and inx.indrelid in
>   (select oid from pg_class where relname=$2 and relowner in
>   (select oid from pg_authid where rolname=$1));
>   if v_count = 0 then
> execute immediate 'create unique index $3 on $2 (acn_id)';
> end if;
> END;
> $body$LANGUAGE PLPGSQL;
>
> Regards,
> Igor Neyman
> .
>

--------------030806020603090301020501
Content-Type: multipart/related;
	boundary="------------070500050208080104080903"

--------------070500050208080104080903
Content-Type: text/html; charset="ISO-8859-1"
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body text="#000099" bgcolor="#ffffff">
    <tt>Thanks Igor Nayman!!! The function worked for me</tt><br>
    <div class="moz-signature">
      <meta http-equiv="CONTENT-TYPE" content="text/html;
        charset=ISO-8859-1">
      <title> </title>
      <meta name="GENERATOR" content="OpenOffice.org 2.3 (Win32)">
      <meta name="CREATED" content="0;0">
      <meta name="CHANGED" content="20090514;17180285">
      <meta name="ProgId" content="Word.Document">
      <meta name="Originator" content="Microsoft Word 11">
      <!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
      <!--[if gte mso 9]><xml>
 <o:DocumentProperties>
  <o:Author>Connoi</o:Author>
  <o:Template>Normal</o:Template>
  <o:LastAuthor>harshitan</o:LastAuthor>
  <o:Revision>2</o:Revision>
  <o:TotalTime>4</o:TotalTime>
  <o:Created>2007-11-30T08:17:00Z</o:Created>
  <o:LastSaved>2007-11-30T08:17:00Z</o:LastSaved>
  <o:Pages>1</o:Pages>
  <o:Words>80</o:Words>
  <o:Characters>459</o:Characters>
  <o:Lines>3</o:Lines>
  <o:Paragraphs>1</o:Paragraphs>
  <o:CharactersWithSpaces>538</o:CharactersWithSpaces>
  <o:Version>11.9999</o:Version>
 </o:DocumentProperties>
</xml><![endif]-->
      <!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:SpellingState>Clean</w:SpellingState>
  <w:GrammarState>Clean</w:GrammarState>
  <w:ValidateAgainstSchemas/>
  <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
  <w:IgnoreMixedContent>false</w:IgnoreMixedContent>
  <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
  <w:Compatibility>
   <w:SelectEntireFieldWithStartOrEnd/>
   <w:UseWord2002TableStyleRules/>
  </w:Compatibility>
  <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
 </w:WordDocument>
</xml><![endif]-->
      <!--[if gte mso 9]><xml>
 <w:LatentStyles DefLockedState="false" LatentStyleCount="156">
 </w:LatentStyles>
</xml><![endif]-->
      <!--[if !mso]><object
 classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object>
<style>
st1\:*{behavior:url(#ieooui) }
</style>
<![endif]-->
      <!--[if gte mso 10]>
<style>
 /* Style Definitions */
 table.MsoNormalTable
	{mso-style-name:"Table Normal";
	mso-tstyle-rowband-size:0;
	mso-tstyle-colband-size:0;
	mso-style-noshow:yes;
	mso-style-parent:"";
	mso-padding-alt:0in 5.4pt 0in 5.4pt;
	mso-para-margin:0in;
	mso-para-margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:10.0pt;
	font-family:"Times New Roman";
	mso-ansi-language:#0400;
	mso-fareast-language:#0400;
	mso-bidi-language:#0400;}
</style>
<![endif]-->
      <!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="2050"/>
</xml><![endif]-->
      <!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1"/>
 </o:shapelayout></xml><![endif]-->
      <style type="text/css">
	<!--
		@page { size: 8.5in 11in }
		P { color: #000000 }
		A:link { color: #0000ff }
		A:visited { color: #800080 }
	-->
	</style>
      <p style="margin-bottom: 0in;"><strong><font color="#939598"><font
              face="Arial"><font size="2">Sivannarayanareddy
                Nusum</font></font></font></strong><strong><font
            color="#000080"> </font></strong><strong><font
            color="#000080"><font face="Arial"><font size="2">|
              </font></font></font></strong><strong><font
            color="#0000ff"><font face="Arial"><font size="2">System
                Analyst(Moneta GDO)</font></font></font></strong><font
          color="#000080">
        </font>
      </p>
      <p style="margin-bottom: 0in;"><font face="Arial"><font
            style="font-size: 8pt;" size="1"><!--[if gte vml 1]><v:shapetype id="_x0000_t75" coordsize="21600,21600" o:spt="75"
 o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
 <v:stroke joinstyle="miter"/>
 <v:formulas>
  <v:f eqn="if lineDrawn pixelLineWidth 0"/>
  <v:f eqn="sum @0 1 0"/>
  <v:f eqn="sum 0 0 @1"/>
  <v:f eqn="prod @2 1 2"/>
  <v:f eqn="prod @3 21600 pixelWidth"/>
  <v:f eqn="prod @3 21600 pixelHeight"/>
  <v:f eqn="sum @0 0 1"/>
  <v:f eqn="prod @6 1 2"/>
  <v:f eqn="prod @7 21600 pixelWidth"/>
  <v:f eqn="sum @8 21600 0"/>
  <v:f eqn="prod @7 21600 pixelHeight"/>
  <v:f eqn="sum @10 21600 0"/>
 </v:formulas>
 <v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
 <o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1025" type="#_x0000_t75" style='width:142.5pt;
 height:53.25pt'>
 <v:imagedata src="e-mail%20signature_files/image001.gif" o:title=""/>
</v:shape><![endif]--><img
              src="cid:part1.09010506.07060500@subexworld.com"
              name="graphics1" width="190" align="BOTTOM" border="0"
              height="71"></font></font></p>
      <p style="margin-bottom: 0in;"><font color="#808080"><font
            face="Arial"><font style="font-size: 8pt;" size="1">Subex
              Limited, Adarsh Tech Park, Outer Ring Road,
              Devarabisannalli,
              Bangalore &#8211; 560037, India.<br>
            </font></font></font><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>Phone:</b></font></font></font><font
          color="#000000">
        </font><font color="#000000"><font face="Arial"><font
              style="font-size: 8pt;" size="1">+91
              80 6696 3371; </font></font></font><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>Mobile:</b></font></font></font><font
          color="#000000">
        </font><font color="#000000"><font face="Arial"><font
              style="font-size: 8pt;" size="1">+91
              9902065831</font></font></font><font color="#c1272d">&nbsp; </font><font
          color="#a01e55"><font face="Arial"><font style="font-size:
              8pt;" size="1"><b>Fax:</b></font></font></font><font
          color="#000000">
        </font><font color="#000000"><font face="Arial"><font
              style="font-size: 8pt;" size="1">+91
              80 6696 3333; </font></font></font>
      </p>
      <p style="margin-bottom: 0in;"><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>Email:</b></font></font></font><font
          color="#c1272d">
          &nbsp;</font><font color="#c1272d"><font face="Arial"><font
              style="font-size: 8pt;" size="1"><a
                href="mailto:email.id@subexworld.com">sivannarayanreddy@subexworld.com</a>;
            </font></font></font><font color="#a01e55"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><b>URL:</b></font></font></font><font
          color="#c1272d">
          &nbsp;</font><a href="http://www.subexworld.com/"><font
            color="#c1272d"><font face="Arial"><font style="font-size:
                8pt;" size="1">www.subexworld.com</font></font></font></a><font
          color="#c1272d">
        </font>
      </p>
      <p style="margin-bottom: 0in;"><font color="#c1272d">&nbsp;</font></p>
      <p class="msonormal"><font color="#808080"><font face="Arial"><font
              style="font-size: 8pt;" size="1"><i>Disclaimer:
                This e-mail is bound by the terms and conditions
                described at
              </i></font></font></font><a
          href="http://www.subexworld.com/mail-disclaimer.html"><font
            face="Arial"><font style="font-size: 8pt;" size="1"><i>http://www.subexworld.com/mail-disclaimer.html</i></font></font></a><font
          color="#808080"> <br>
        </font></p>
    </div>
    <br>
    On 2/16/2011 9:54 PM, Igor Neyman wrote:
    <blockquote
cite="mid:F4C27E77F7A33E4CA98C19A9DC6722A207221F44@EXCHANGE.corp.perceptron.com"
      type="cite">
      <pre wrap=""> 

</pre>
      <blockquote type="cite">
        <pre wrap="">-----Original Message-----
From: Sivannarayanreddy [<a class="moz-txt-link-freetext" href="mailto:sivannarayanreddy@subexworld.com">mailto:sivannarayanreddy@subexworld.com</a>] 
Sent: Wednesday, February 16, 2011 7:36 AM
To: <a class="moz-txt-link-abbreviated" href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>
Subject: Function compile error

Hello,
I am trying to create the function as below but it is 
throwing error 'ERROR:  syntax error at or near "DECLARE"', 
Could some one help me please

CREATE FUNCTION check_password(databasename text, tablename 
text, indexname text)RETURNS VOID AS 
DECLARE v_count INTEGER;
BEGIN
  select  count(1) into v_count  from  pg_index inx where  
inx.indexrelid in
 (select oid from pg_class where relname=$3 and relowner in 
 (select oid from pg_authid where rolname=$1)) 
 and inx.indrelid in 
 (select oid from pg_class where relname=$2 and relowner in 
 (select oid from pg_authid where rolname=$1)); 
 if v_count = 0 then  
execute immediate 'create unique index $3 on $2 (acn_id)';  
end if; 
END;



Sivannarayanareddy Nusum | System Analyst(Moneta GDO) 



Subex Limited, Adarsh Tech Park, Outer Ring Road, 
Devarabisannalli, Bangalore - 560037, India.
Phone: +91 80 6696 3371; Mobile: +91 9902065831  Fax: +91 80 
6696 3333; 

Email:  <a class="moz-txt-link-abbreviated" href="mailto:sivannarayanreddy@subexworld.com">sivannarayanreddy@subexworld.com</a> 
<a class="moz-txt-link-rfc2396E" href="mailto:email.id@subexworld.com">&lt;mailto:email.id@subexworld.com&gt;</a> ; URL:  <a class="moz-txt-link-abbreviated" href="http://www.subexworld.com">www.subexworld.com</a> 
<a class="moz-txt-link-rfc2396E" href="http://www.subexworld.com/">&lt;http://www.subexworld.com/&gt;</a>  

 

Disclaimer: This e-mail is bound by the terms and conditions 
described at <a class="moz-txt-link-freetext" href="http://www.subexworld.com/mail-disclaimer.html">http://www.subexworld.com/mail-disclaimer.html</a> 
<a class="moz-txt-link-rfc2396E" href="http://www.subexworld.com/mail-disclaimer.html">&lt;http://www.subexworld.com/mail-disclaimer.html&gt;</a>  

</pre>
      </blockquote>
      <pre wrap="">


CREATE FUNCTION check_password(databasename text, tablename text,
indexname text)
RETURNS VOID AS $body$
DECLARE v_count INTEGER;
BEGIN
  select  count(1) into v_count  from  pg_index inx where
inx.indexrelid in
 (select oid from pg_class where relname=$3 and relowner in 
 (select oid from pg_authid where rolname=$1)) 
 and inx.indrelid in 
 (select oid from pg_class where relname=$2 and relowner in 
 (select oid from pg_authid where rolname=$1)); 
 if v_count = 0 then  
execute immediate 'create unique index $3 on $2 (acn_id)';  
end if; 
END;
$body$LANGUAGE PLPGSQL;

Regards,
Igor Neyman
.

</pre>
    </blockquote>
  </body>
</html>

--------------070500050208080104080903
Content-Type: image/gif; name="graphics1"
Content-Transfer-Encoding: base64
Content-ID: <part1.09010506.07060500@subexworld.com>
Content-Disposition: inline; filename="graphics1"

R0lGODlhvgBHAHcAACH/C01TT0ZGSUNFOS4wDQAAAAFzUkdCAK7OHOkAIf8LTVNPRkZJQ0U5
LjAXAAAAC21zT1BNU09GRklDRTkuMEI8pPUALAAAAAC+AEcAh4ODg4uLi6KiotqpvP/BCf/T
U50aUPfs8P/IJe7Z4cuGosyJpfnw9P7yy/De5q9GcZwZTzY2Np4dU/71254eU3x8fLFKdf7c
d7Kystmmu2tra8nJyXV1df/ABfz8/Pz5+v/nnL5pjJUJQ6s9ar1miu3t7f/CDFtbW//RTPv1
+P/hiP/78ZqamsZ7mv7uuuHh4f/pqP78/dGVrsTExPny9f/DEqmpqdHR0f/77SwsLPHx8fXp
7uG6yvLh6KEmWKAgVb29vf/01UxMTNra2urO2VRUVKYyYv/MNM+QquXl5dyuwblehLm5ufXn
7f/NO7ZVfc2NqOnK196yxOK+zK1BbqUvX5oVTJsWTf/FG56ent3d3f++AJ4fWrtghv+/ApkS
SuTAz7RReZGRkbhagdfX1/r6+vr09/T09P37/Ojo6JsYTvz6+6g2ZRkZGfj4+Pb29uTB0N+0
xezU3v/9+dCQq6QtXpaWlv/5566urp4eUsmBn8HBwf/abKIoWs3NzUJCQiEhIdSbspkUS9Wd
tJwcUsR1lmRkZOXE0fPk6ufJ1f/rsMFxkqAkV5gQSJ8iVqMqXNCTtJ0cUMBukKQsXrlcgv7X
Yba2ttahtuvS3NejuKo4Z6YrS5wXTwgICPHg56AgVv/+++vQ2/7AA+3W4MN1lfTl654iVZwc
WrNRebBIcqQqXfry9tOYsOC3yJoSS+zT3ch+nP+9AMV4l/7YZtCSrJ8iVP/fgrNOd92ww5kV
TJ0dUr9sjv7337hZgObG1JcOR5gSSdSbs/+/A/ry9fjv85gRSZ8eVOS/z50bUZsaULVTe5kT
S50fVKQrXZ8hVf7////+/////p8gVaYuX/7+/58fVP7+/p4hVf/+/p8hVP7//p4gVPz4+Z4g
Vf79/frz9p8iVcJzk6YtX+/b47xROuWVHeSXIZ0gVf/1stF4OfPk79+2x5kXWLdXf//vwP/M
Abldib9ukf/71f76++ymL54hVOKZQ//HAJkVTf2+AP/LEf/HCNuswNurv6AhVv///wj/AP8J
HEiwoMGDCBMqXMiwocOHECNKnEixosWLGDNq3Mixo8ePIEOKHEmyJEhtJlNO/CADChI6MOlA
yRRDpc1/KG/qVMhA2q9iQIGKGMFtp8cY1IwqZUhjmgRn/qL6M5Dqw1KJ2KbIUCBLEoklS5T1
WtJlESwoYKxeXUqjylOpUx+ovWotWrR/dxN6oiCir9+/In4JjvRggYO1Rtu+lWpA7tW8Dg88
obKkkB4kmDErWHRrkg9CgtnE8Yb4pmKojB0jnuMwRtGEaA4k4KGHTTFkFsCUVnkabuO5SkFd
OHKBF0FoAyFHbBJuWaMRxAQi3y2yd2rgRoMQELYFwYUg/54J/7SrPOKaXcuWFZIObTp1j9aj
/l7boMYWAgS21LjgAsezZ9hcNI8sySCjxEDuvcdRfHFhtxM27lSChTD4eUEAAjD8lxEJjRhx
QHgkIVeeaW6hJp9qB4n3TIIWtQciQrzwYV8HBNBYQAMF2SVRP1fgk4GCITE4H3UT2OLEdiYI
YwIf4I03IkOJOLIMCQGG9IEDYPCTQSsOOJiSkCgO1MMhUmQgBRHfbIRGKVGsk8EAPLxyAGkF
geICCjSaIEoNs9xRkSePQGBEmh8NwwoVfVRjgBoU9PGAHuMcN9AaSrw5wKUDZKDEGgvJkQmm
l25Zk0BgztXEJb304QwyakTiCBskZP+QgkVEQGFBH45IoAajPjSjDCujCCSeQNjYUoMXJhAQ
ixMTjDesQ000Y8AjTXyUwQhXQEBBNT/8UA0FBiwzzQLV/lPlPzT4YAUE7LIriA80LASFCO2y
CwwVr6Fbom8PoPHPGrTUYQUneVQjTbfVSGCFIBbw4G9EDpCwzTIQGFMNt94ao6sgjFCCiUEN
FJCknhgK+yRCDvSBTDOldMSAJJxA4MzMcEkTlQRXGLFAQTSII0G3QBMyTbwKIVHMwUBDgKKQ
FqQQTCoQRGIzXDW3moovDA17zBiPXEEB1VQ7Iw0FV/RBSRwEiecOCqLg1wEKzUIUBSMrt7wR
N100Ik02M5v/GNUPUK1qhQIENSUB1bpMw8BCRvs9pL6LRYVbC8uo4QzfYEsljTPb5DKJbgxF
8cgXeUhFc9j+0MyMIBBIIZA22iAHDQhYdGBCd4pAJAUykbDMkQLL/JD58NVYAcVrhlMtwdCM
f+H40vtq/ogz1QxvvQE/rINXQS7+A4e0mV/Ttz/ig42MD7ggCKI7WNxHowoLdU+LIHnUEZ1G
ozByuPVgO3JFHZ4glVOUx7yiOY9fc2GQI6QxNf6BDRzIYATWnvUP5HhjAXQbntiMsS3MgY0Q
eYDFw/LyDF6oAAv4EUUl/HQygTCACsiAQBg8sJEMWCFzOLMC9qiGDFUcYiDJg8vy/4iWECQc
8DpAjF5UnHGNT9RMV5xQgwSqB7aZWeEW+ZLOPxKhBmT47W/hggAjEpULTlDRdM7QxRV+iBxr
COsfisDP7ZzQJINoKBOCcMYyYLG9jOgBGGG7wjR2IYkHqMGMqTMAOH4IxAEKsYBFPOKJEqhE
1KAGGcswABso0YUxaEICgtDFEk/nDEHI4CC7sAIpxdZFKuihH0QYxxRYsQRGWOFrcPEfCQZy
LoHAoH0m8AIC/ISQNaRCDdK4wo9aCBFsLEENNdNFCA7zD25kQhkSoAAywMEKnjlSKkNs3vMo
GTmqqWEEsojD/dA1BVlUwXKpc2JUdNGHYBEkA5E448woQP8IC/AjiwOJQhcYYYDT+eMHBrhE
QhqAAgIEswBxMwgrkCkBAKrpFgaAS6Psxksl5KEPcDBIEMEJSYQYcZxJLKdUrmABRCTEAe1Q
pd+cYYUx0OkfKUOGVD6RDWboIhCjShtBEsGGgpooEj6IFEKiUQn9iAIL7jCIAz7jD0GEoyNL
4ITppBGJfhwECTwYyLNGerOSflWSDUrpFx1hhQdwVDrPgAwDnnAFgzqDAoyw5z8WsAy/SWMZ
ejgINSj4DyL4oHRwWcbODBKNweIABfkwQQewYByCBMMKDFRDWFlkEVgIIpcSeAQSXNoQsvoj
nAZEKamUKDxkjCABDSkFGwgxU0H/0EIgZqBCQeFCiCoE0CGLuALVDEAFIh5kDhcwQZJQUNl/
YIINXoQAFjdyFyXscIn+0EUupqGH3yrEtKiNpGohZyKxGeBA0EjKQoAHtlzsQiChcAQz4NIN
NQwCIgnwgTFM1w1OHGghF9hCMBEAHk+wQWbMQEZYN4KccejPdKZwxA90IYg6ZOCmBwGvWQ1y
UgSqFS7MYARsqaFehYTCH/vFrhra4UYeSIAZJpKGI9rRhRrb+MY4rnEzzpg6VywWIQGaQwEE
7IUjTAAegnDEqvDFEfFYQxJ6m2nqIiFDtCFEw8Y963gZFAlNzIqwCImBBTKKXapYZQAQ2Bxc
nGEATrj5/81wjnMUZUw1K6yHIY8VhQneYY9TzBccXwgBSL7RAghsY3jduIIB2mHlCjZyfyTN
MofR+jgGWUESDxGPAr6gvBHMSgbLcKCorceJXWZtBSi4hzk2sT8J9CEUIpFFMeYLtmv4I5lq
WMTi3INlcXp4teUsBhQekpRMCFeIVYiX0UbNbHNSgrMGwcYz5EGPTZzictIQxGKhfRHkEOMJ
u6pi4KrRCEEXzmcElHRBOoxEYPutGLd1CHL6cd2yKpvTzc43BJQR1IS4UR0jMEA29gaBEXzI
XCHhBg8oAYxIOEPJX0ToLswwEG6MwIsanUS5iliM5+WLQcD4sUMGcUNkK7sYYP/bhgR0IYGW
u/zlMI95y60Qhn4nhAEWOLY/KOADIoxEQ/9IgQLqIAgKeBAu5P7xBx5ggAbu3HcKgQLK4aKG
J9zU0vGIiB7wDU5NUJwWrqCaNPowjSpM4+xoT7va1372PizB5pL6BwPG8FmpsIMcIBgPSJ5B
Dfd4Qg/++AIh+keISfRAIDG4BQRsLRUKPMK7CGmBIMoXlSt0oXCVbMzDHEIJaMIFGUy+LNWu
EAIz0OD0qE+96lefejMkBcwDmfsyGH9aQpRDHzjSBjMtAuZj7KKoflOybQdCgivIMyrG8IEc
FiKJKzjdCovAfDk/CvmFJKAPuFzivmtiXeFJxbWLIwn/N0jgPEekzhhcSMc+OuAEFtqkCajQ
+RKtYOp/UI72/mCGNECHEDSM2W9fMGwftkTboAYDkBwLAQuAtGaXJhBRAmOaY0oQAXQMkV7i
UQq9oHNiwwmQgA7KFQt88CIqkQBVoFNSkQ0r5kb/AGqpozmccIB2JB7j4AMUYCI/oAaZIH1+
JV1FwW0Vp1tgUwyE8w+IgH3llQyaEH4dMR2IkArL0EDOoAZUYBWzYCEIsAIhMQCnhBCDwAne
5w/ZsH0CEQdNt2ZXUH9C9Q+wgFmAExXVwAxYM4Cmgw8tgGEIsQBq8IVR4VMh9Q8eoAzyd2tq
4FUO0SUQ8QG9AAxqdjNXoFD//+AODiUMtsARkCEDPgABlOBzFdQ961Bv/iCG/7ADRiBKWxUJ
sjAX7oEEF8NDI6CE5AU20gABvfBWIogJXTBFYUN/N3UIFEBrSyQBk3A8OdJH//AKJNAHFtAC
SiWCBsEDFmCCqZMr4PAjAgEKfGAhJpA7jnYR0SAeMhBK5+AKRiAFGLYDFgABpnMNajAGJSYJ
eYRGq/MEr0AQKUAHVwBpUrEMLUCMDKI5X5AKU8ApBBEDUvAIguB0N+MIH0MQ6LFmabQMYbCM
BfENUPAIy0AByVAMRqAAvzVYBjEIOFMzzKAGwYCAOIAAHSAKV/gMOYERieBTM+MIMRQGlzAK
43AMt/8gf5cjCO81EFNgAPrkD0r2P+FABzLQAjC0DV/0CVbgVZDRj0t0DRCgC6mwAHFwCOsA
BWGQB7QFNp/wBXxUEA5Qgmi0QDnTAlLQA6d3AIcgAxaQC7rQN+AQCa4wDYEwKwaBC63iNz9Q
DLJgRyBgO16gAhRoEa2gCdAYFdJwSD7QB9JAZmhkBTk4EN5QCHX1RadlBV+wDIKAcWs2FZqw
A9v4iqYDDjUDAVZwOBJAMTzWgs5whnhZEHqplF8ESoSgCmYnDv6wLkJpOv4ADoLwAOUyHQkQ
Ag+GRsswBq44EKBQCRSCBRFlEaWgCkmWOZ9gDBZTRVJIKI62A1UQCdmQb1L/UQ0vOJqkGRUD
h5nSsIoaFAnMECwUZEEkAAyHljnSoDEt15pL9AO60oeOlgBG8AXZ9wnXUAuC0A7LSRAu4FBe
AAKwZx4KgA/Zx2w402j/oF6k8AsQmG/S0AjRZ54MYgrGkAzi+YkQUJLM6JFz1wgTKp7hQjjP
QgRUUFdUYwptJZoJcQco5AUF8KASsQCcgI8tmDm5IgFIgBClQAIGIKQOVDwhkKDnuXOakJMp
NmpqwAbUaEexpweOgI7i+QOcYARbKB7fQAt9YDnjAxVXwAawthAqoCQm4AIbMQiM4HypY1Dx
BBUGYDwLkQHVoAb1wETjM0p9kwxXUAgCKVJVEJfj/wMBFvANCqALBgBxtbY5eXAv1KQQ08ED
bFB0fIOnaDQzhPAFDyCR46AMxUAIpkmogpAKh8cQoOAEHcB+rOGjDaFeofAExSAIS3ox3vIt
yHAFgsAGMLgQA2AEgqBousAM+reezCABBnAFjaAJhFhihcMIxXAFVrCtVvALI1ATU8AGjXAF
yFAwF8NBrPIFPqAAH1KYBkFiArEDCuAD2YoMEmAx3HIxeUBlVlAMbCADq0AQ/TANV0B5oxSc
tHgQOgICyEIAcqp7GcENrEACFlAHjKAoxiANzTAC7YAEONoQO8AKXUAFRsAI0iAByCANjDAN
qdAFCkBa5jkQKUAKIbALNv9rsySgAA8zDgowsn1wWhIwdiPwBIWgie4qWARBBApAAlRQBT8r
ARBQDWPEBqgQAlAAs0RICl0EDngqDVZABQvpECtwBB0gDAUACsSYEWtwAKFwDErAA3BQCrEp
EdxAA3IAB1KgBGBABDvgJRfBDZ5wCK2wDnAwDilghxXBDQyQAFg5AFOQCJ7wDTYXA6xQB4gE
F+KTbSRwcBABA7ZTA+Cxe0AyuhUxHdyAHokZlczACaSQqBBxkrOaO6J7EbbaENMxHbXLe2+0
iR8BDbAXBcqgBtWAmf6ADMXQBdYKEdGAAtwBP7NLutDLEHkxCl3gD1pFpAZQB4MApQ9hCxZy
BFj/GL034QFlUBIosQYy0Ay3lDkzowZ1oIkW0QDK1QGKkLviaxBAAAQVIQAc0BBnkAUAIAYv
MBBDEAAVgAc0JBAbAAAawAIJjBfe0ALFEAnkg5nMkAvNYGU+2BBzQLZbwAf2WxLlSxAeQCcq
SBAnrAMFUb43cAMD4QGu6wFvYBB+IAY0FAAn4IcrXBBDAAhMgAF/4MIscAKWMAMAIAQqzL9A
cAN+8MBbpAtfM6jgxAwL8Krc+A8qQCPDtBRuwAFDfAID/A82UARFsAf/sAEBcMYAcMZi8A/e
UAF/wAFu8A9DvMZAsAFnHAAaUARaIBCWIAQnoAF4PBAa0AYnUAJ28Adw/6y//6AFJyAETEAQ
QxABAhEBTLAGOeAHA/EHM+ANOUAGCDEAnFCfo5Q6wSqAGzEBNVAj2mgUbmDIabDH/wAEOXAD
GAAIaaAFOSDGOeAGAtDGNmAHb6ABGPAPRQDG/2AHNvAPWfAHL2AHGvAPblDGaZADyzwQNnAC
SeABdtAGN8ACOVAGbiAEGEAGOZAEA6HLAgAAhlAGL5ADMywQB/zOZ4AQGaAGpHxr/tANgtAM
1BjCHOzBF7AUZ5ADePwCgOABGlABAiEELPAPf7AHY4wHAjAExgwAGFABy2wIliAQLIAHzPzQ
GyAE//ACafwPhnDNAsEE0fwPOPwPOtAGZzADOf+AAUBsxgKhBYBQAUWQBSWdA/UsEByAAfSM
EGBACA3kCDKpBiSwfJQoEBcQC7FQAASdAzPwDzeQA9agAS39B8ssBkUQACNdAeV7AjZQAmdA
GoYQyXQM0gJgB2dM0mnQv/9g1gRhCS390iUACGewAedcAmWQqJP8D3tdAh7wB2380wMsBIxs
ECnwAHW3QFagCvcVErxQALNQRzvhBoDwBxggBGuc1SzAAX9Qz1rQCWucAzn8DxhgCEDABCVQ
18X8D2KwzCzQxjPwB9bgAUXAAQIACCA9EBsQAfp7xITdCYAtBBqQvydszm/gycs8A4AQADYQ
AWv8DzPg0HuAAa77D3KyMALAsAzZ2gWwRRJHaxNnEAEG/NAC4QccAACx/Q/WYAcWbQNs/Q8C
UAEAkAasbdH/4AegfAN4nAQ24EZJEABZwNgEUQYGfMYg/QZiUM9nYMACcMIlwALliweMTAYA
UAGzvdIcUAEsgGHicQCBoAcKgAu9NBLPGxIF7cIl4QEsYAcAIMdAog0AbREtDhIeMAMqbBJ+
EAAs8OP3W+RGfuRI7hAnnORMXhpL3uRQHuVS/h4BAQA7
--------------070500050208080104080903--

--------------030806020603090301020501--