Thomas T. Thai writes:
> i'm parsing DMOZ data files, and i need to store the path and later
> reference it to get the associated CatID to store for the parent of the
> child paths. however, some of the paths are larger than 500 chars. would a
> WHERE clause like this:
>
> ... WHERE path='top/this/really/long/500/char/path'
>
> work if i define the field 'path' as type text?
Sure, you can store up to 1 GB in a text field.
> also, type text field aren't indexable or are they?
Sure they are.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter