Re: TEXT question... Was 7.0 key features

Mitch Vincent wrote:
> 
> This brings me to another question. Hopefully there isn't a 8k (max 32k)
> limit on TEXT fields -- 

No, they currently just have to fit in a record ;)

They will be stored (optionally) separately in future (7.1)

> 
> What do you guys think of storing whole text files (normally stored in a
> flat file) in the database for searching purposes? Would a search on an
> indexed TEXT field be slow as mud?

Depends on search ;)

like "a%" may not be too slow (unless the indexes on text field will be 
disallowed initially, as has been mentioned some times)

PG does not yet have a native full-text index. There is a suboptimal
implementation using triggers and extra tables in contrib.

----------
Hannu