Hi Team, I have installed "PostgreSQL 9.2 in my local machine". And I am trying to execute the below statement.
statement: "DECLARE v_num number". And I am getting the below error: type "number" does not exist. And its not supporting any oracle data types functions.As I knew "PostgressSQL9.2" supports pl/sql data types and functions. Kindly suggest what can be the issue and how to go about it v.pravallika Tata Consultancy Services Mailto: vanukuri.pravall...@tcs.com Website: http://www.tcs.com ____________________________________________ Experience certainty. IT Services Business Solutions Outsourcing ____________________________________________ =====-----=====-----===== Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you