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