Re: [SQL] Full-text Indexing and Primary Keys

2001-07-23 Thread Chris Ruprecht
file on hard drive by content" - which, if not indexed, takes forever. Hope this makes the issue a little more clear. Best regards, Chris - Original Message - From: "Josh Berkus" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, July 23, 2001 10:32 AM S

Re: [SQL] Full-text Indexing and Primary Keys

2001-07-23 Thread Giles Lean
Josh Berkus wrote: > 1. Can anyone explain to me what "full-text indexing" is, and why we do > or don't need it for Postgres? The marketing types keep asking me about > it ("buzzword o' the day") and I don't have an answer for them. Full text indexing: something like google does for HTML pages

[SQL] Full-text Indexing and Primary Keys

2001-07-23 Thread Josh Berkus
Folks, 1. Can anyone explain to me what "full-text indexing" is, and why we do or don't need it for Postgres? The marketing types keep asking me about it ("buzzword o' the day") and I don't have an answer for them. 2. I propose that future versions of PostgreSQL require a primary key at table c