Re: [GENERAL] Size of varchar in an array

2011-02-12 Thread Dmitriy Igrishin
Hey, 2011/2/8 RW Shore > I'm using the following type definition: > create type typedef.BASIC_PEDIGREE as ( > DATE_ADDED TIMESTAMP, > DESCRIPTION VARCHAR(128) [10] > )\c > > I understand that PostgreSQL doesn't enforce the array length [10]. > However, I'd like to write an applic

[GENERAL] Size of varchar in an array

2011-02-08 Thread RW Shore
I'm using the following type definition: create type typedef.BASIC_PEDIGREE as ( DATE_ADDED TIMESTAMP, DESCRIPTION VARCHAR(128) [10] )\c I understand that PostgreSQL doesn't enforce the array length [10]. However, I'd like to write an application that can retrieve this length AND t