| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Vanukuri Pravallika <vanukuri(dot)pravallika(at)tcs(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: PostgresSQL 9.2 Installation |
| Date: | 2013-02-13 13:00:53 |
| Message-ID: | 511B8E85.2040603@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Little, Douglas | 2013-02-14 20:50:50 | query saved during crash |
| Previous Message | Vanukuri Pravallika | 2013-02-13 07:27:13 | PostgresSQL 9.2 Installation |