Postgres Pro
Downloads
Home   >   mailing lists

Re: (plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "(" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: (plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "("
Date
Msg-id 11969.1014336445@sss.pgh.pa.us
Whole thread Raw
In response to (plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "("  (Angus Lees <gus@switchonline.com.au>)
List pgsql-bugs
Tree view 
Angus Lees <gus@switchonline.com.au> writes:
> from a quick look at plpgsql/src/gram.y, the decl_dtypename rule
> only allows type modifiers (decl_attypmod) on CHAR, VARCHAR or BPCHAR.

This is fixed in 7.2.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Angus Lees
Date:
Subject: (plpgsql) DECLARE foo NUMERIC(5,2): syntax error at "("
Next
From: Justin
Date:
Subject: Re: Full bug list