From: Sivannarayanreddy <sivannarayanreddy@subexworld.com>
To: Igor Neyman <ineyman@perceptron.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: Function compile error
Date: Fri, 18 Feb 2011 11:14:53 +0530
Message-ID: <4D5E0755.2080304@subexworld.com> (raw)
In-Reply-To: <F4C27E77F7A33E4CA98C19A9DC6722A207221F44@EXCHANGE.corp.perceptron.com>
References: <4D5BC495.5000605@subexworld.com>
<F4C27E77F7A33E4CA98C19A9DC6722A207221F44@EXCHANGE.corp.perceptron.com>
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
> .
>
Attachments:
[image/gif] graphics1 (5.5K, ../4D5E0755.2080304@subexworld.com/3-graphics1)
download | view image
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sivannarayanreddy@subexworld.com, ineyman@perceptron.com
Subject: Re: Function compile error
In-Reply-To: <4D5E0755.2080304@subexworld.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox