Thread: PostgresSQL 9.2 Installation
"DECLARE v_num number".
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.pravallika@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
On 13/02/2013 07:27, Vanukuri Pravallika wrote: > 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 You probably want the NUMERIC type. The data types available in pl/pgsql are the same as for plain SQL: http://www.postgresql.org/docs/9.2/static/datatype.html Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie