Re: Column Type Suggestions

>
>
>
> Initially I had planned to use Postgresql's Array Column (keywords
> varchar(100)[]) but this has some limitations when using the LIKE operator,
> making searching for specific string of words difficult unless you know
> firsthand the array key (keywords[2] LIKE 'PANA%').
>
> Does anyone have any suggestions? Product keywords could vary from 1 up to
> 20, maybe more. Performance isn't a huge issue since the database table
> will
> be fairly small and on a local network. Appreciate all the input! NOTE:
> Using PHP5/Postgresql 8.3<http://www.postgresql.org/mailpref/pgsql-general>
>

Sounds like a seperate table with the primary key of your product table and
the keyword you want.

--
Chris Spotts
rfusca(at)gmail(dot)com