On Tue, 18 Jun 2002, Josh Berkus wrote:
Wei,
Is there any disadvantage of using TEXT datatype as opposed to a VARCHAR
datatype with a maximum length, especially when I do searches on them?
Yes. You can't index TEXT because it's of potentially unlimited length.
Well indexing text
On Tue, 2002-06-18 at 18:07, Wei Weng wrote:
Is there any disadvantage of using TEXT datatype as opposed to a VARCHAR
datatype with a maximum length, especially when I do searches on them?
There is one big disadvantage that I've found, but might be utterly
unimportant to you. Some applications
On Tue, 2002-06-18 at 18:59, Josh Berkus wrote:
Wei,
Is there any disadvantage of using TEXT datatype as opposed to a VARCHAR
datatype with a maximum length, especially when I do searches on them?
Yes. You can't index TEXT because it's of potentially unlimited length.
--
-Josh
I have no trouble indexing TEXT datatype in postgres-7.x
- Original Message -
From: Josh Berkus [EMAIL PROTECTED]
Yes. You can't index TEXT because it's of potentially unlimited length.
---(end of broadcast)---
TIP 2: you can get off