Re: [SQL] Function compile error

2011-02-17 Thread Sivannarayanreddy
/mail-disclaimer.html On 2/16/2011 9:54 PM, Igor Neyman wrote: -Original Message- From: Sivannarayanreddy [mailto:sivannarayanre...@subexworld.com] Sent: Wednesday, February 16, 2011 7:36 AM To: pgsql-sql@postgresql.org Subject: Function

[SQL] Function compile error

2011-02-16 Thread Sivannarayanreddy
Title: 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 V

[SQL] Oracle Equivalent queries in Postgres

2011-02-16 Thread Sivannarayanreddy
Title: Hello, I am checking the compatibility of my product with Postgres database and i stucked in forming the below oracle equivalent queries in Postgres database, Could some one help me pleaseee 1) Trying to get index and corresponding columns  information of a

[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