| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | "Thomas T(dot) Thai" <tom(at)minnesota(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: datatype for indexable char field larger than 256 |
| Date: | 2001-07-08 09:39:46 |
| Message-ID: | Pine.LNX.4.30.0107081138390.677-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net http://funkturm.homeip.net/~peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter C. A. =?ISO-8859-1?Q?B=E4r?= | 2001-07-08 11:45:35 | Re: libssl.so.0, libcrypto.so.0 needed when installing RPM 7.1.2 on RH 6.2? |
| Previous Message | Mithun Bhattacharya | 2001-07-08 09:07:27 | Re: Why is it not using the other processor? |