Обсуждение: test data type

What are the limits of the TEXT data type in PostgreSQL 6.3.2?  I have some
fairly large memos currently in msaccess that I'd like to pull into
postgres (I'm going to convert the entire database into postgres).  Some of
our existing memo fields literally have a few pages (ok, generic term, but
translate into the more specific "LOTS") of words.  Is there a limit to the
size of TEXT data types?  What about searches on this type of field?  We
don't need to search our memo fields often, but stranger things have
happened!  Thanks for any help!
JT

    Hi!

    In the source tree of Postgresql you'll find:

    postgresql-6.4.2/contrib/fulltextindex

    and you'll read README:

---------
The included software is an attempt to add some sort of Full Text Indexing
support to PostgreSQL. I mean by this that we can ask questions like:

        Give me all rows that have 'still' and 'nash' in the 'artist'
field.

Ofcourse we can write this as:

        select * from cds where artist ~* 'stills' and artist ~* 'nash';

But this does not use any indices, and therefore, if your database
gets very large, it will not have very high performance (the above query
requires at least one sequential scan, it probably takes 2 due to the
self-join).
 ....
....
---------
    I haven't tried, nor I'm sure this is the best solution...
    Hope this helps!

,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
`````````````````````````````````````````````
Silvio Emanuel Nunes Barbosa de Macedo
mailto:smacedo@inescn.pt

INESC - Porto - Grupo CAV
Pc da Republica, 93 R/C   Tel:351 2 209 42 21
4000 PORTO  PORTUGAL      Fax:351 2 208 41 72