| From: | "Blake Starkenburg" <blake(at)oldride(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Column Type Suggestions |
| Date: | 2009-10-29 20:34:10 |
| Message-ID: | IFEKLFOMIHMILPPMMCFEGEBMKHAA.blake@oldride.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 pair of Levis may be CLOTHING -> LEVIS -> STONEWASHED -> BOOT CUT ->
36x34.
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2009-10-29 20:42:25 | Re: checkpoints/bgwriter tuning verification |
| Previous Message | Brad Nicholson | 2009-10-29 19:58:57 | Re: checkpoints/bgwriter tuning verification |