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. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
