Thread: datatype for indexable char field larger than 256

datatype for indexable char field larger than 256

From
"Thomas T. Thai"
Date:
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? also, type text field
aren't indexable or are they?

suggestions are welcomed. thanks in advance.


Re: datatype for indexable char field larger than 256

From
Peter Eisentraut
Date:
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