From: | "Tim Perdue" <perdue(at)raccoon(dot)com> |
---|---|
To: | "Mike Frisch" <mfrisch(at)saturn(dot)tlug(dot)org>, <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Large, searchable text fields? |
Date: | 1999-04-26 02:47:22 |
Message-ID: | 005b01be8f8f$1c889140$0b8c5aa5@timnt.weather.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Use 'text'.
You will still run into the 8K limitation, where the total SQL length can
only be 8192 bytes (on my system it's more like 8100 bytes).
Tim Perdue
PHPBuilder.com / GotoCity.com / Geocrawler.com
-----Original Message-----
From: Mike Frisch <mfrisch(at)saturn(dot)tlug(dot)org>
To: pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)org>
Date: Sunday, April 25, 1999 9:19 PM
Subject: [GENERAL] Large, searchable text fields?
>Is it possible to create a text field (<16k) that is searchable using
>regular expressions? I see there's a 4096 character limitation to the
>'varchar' data type.
>
>Thanks,
>
>Mike.
>
>======================================================================
> Mike Frisch Email: mfrisch(at)saturn(dot)tlug(dot)org
> Northstar Technologies WWW: http://saturn.tlug.org/~mfrisch
> Newmarket, Ontario, CANADA
>======================================================================
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-04-26 02:53:33 | Re: [GENERAL] advice on buying sun hardware to run postgres |
Previous Message | Eric Enockson | 1999-04-26 02:46:28 | advice on buying sun hardware to run postgres |