Horton
Menu

Re: Adding a typmod field to Const et al

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gregory Stark <stark@enterprisedb.com>
Cc: pgsql-hackers@postgreSQL.org
Date: 2007-03-17T00:46:12Z
Lists: pgsql-hackers 
Gregory Stark <stark@enterprisedb.com> writes:
> I'm not entirely convinced by this one. Does that mean expressions like this
> would throw an error if col1 was declared as a numeric(1)?
>  ARRAY[col1] || 10

No, because the result of the || operator won't have a specific typmod.

			regards, tom lane