Re: [GENERAL] Large, searchable text fields?

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@saturn.tlug.org>
To: pgsql-general@postgreSQL.org <pgsql-general@postgreSQL.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@saturn.tlug.org
>  Northstar Technologies        WWW: http://saturn.tlug.org/~mfrisch
>  Newmarket, Ontario, CANADA
>======================================================================
>