Re: varchar(n) VS text - Mailing list pgsql-general

Paul Lambert wrote:

> Looks like my bad - I created the table initially through pgAdminIII and
>  it appears I selected the wrong character varying from the dropdown list.
>
> CREATE TABLE tester
> (
>   test_varchar character varying[],
>   test_text text
> )
>
> If I change it to character varying(20) it works fine.

Yeah, what you chose is an array of varchar.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.