Re: datatype for indexable char field larger than 256 - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: datatype for indexable char field larger than 256
Date
Msg-id Pine.LNX.4.30.0107081138390.677-100000@peter.localdomain
Whole thread Raw
In response to datatype for indexable char field larger than 256  ("Thomas T. Thai" <tom@minnesota.com>)
List 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 by date:

Previous
From: Mithun Bhattacharya
Date:
Subject: Re: Why is it not using the other processor?
Next
From: "Peter C. A. Bär"
Date:
Subject: Re: libssl.so.0, libcrypto.so.0 needed when installing RPM 7.1.2 on RH 6.2?