Re: datatype for indexable char field larger than 256

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: datatype for indexable char field larger than 256
Дата
Msg-id Pine.LNX.4.30.0107081138390.677-100000@peter.localdomain
обсуждение исходный текст
Ответ на datatype for indexable char field larger than 256  ("Thomas T. Thai" <tom@minnesota.com>)
Список pgsql-general
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


В списке pgsql-general по дате отправления: