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
======================================================================
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?
Show quoted text
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
======================================================================
Import Notes
Resolved by subject fallback