On Thu, Oct 29, 2009 at 9:34 PM, Blake Starkenburg wrote:
> I am in the midst of planning for a new database which will contain specific
> keywords relating to different products. For example a "Microwave" may have
> the keywords HOUSEHOLD -> PANASONIC -> CAROUSEL -> CONVECTION -> 2200 WATTS.
> A
>
>
>
> 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 ha
