Re: [GENERAL] datatype for indexable char field larger than 256

2001-07-08 Thread Peter Eisentraut
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

[GENERAL] datatype for indexable char field larger than 256

2001-07-07 Thread Thomas T. Thai
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'