From: | "Chris Ruprecht" <chrup999(at)yahoo(dot)com> |
---|---|
To: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
Cc: | "p-sql" <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Full-text Indexing and Primary Keys |
Date: | 2001-07-23 16:28:08 |
Message-ID: | 008301c11394$75418400$5dd26383@corp.compucom.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Josh,
Full Text Indexing
It will allow you to store text into a database and find portions of this
text again, based on a few words of the text in the record.
Say, for example, you want to store the bible in a PostGres database. You
will store these fields:
1. Book
2. Chapter
3. Verse
4. Verse text
If you know your bible, you probably can find any passage by just going to
book/chapter/verse directly. But if you're not, and you just want to find
all verses, where "Nathan", "Solomon" and "mother" is mentioned, you need
something which lets you do that - and fast.
What you want is something which does:
select verse_text from bible where verse_text contains 'Nathan & Solomon &
mother';
or even:
select verse_text from bible where verse_text contains 'Nath* & Solo* &
moth*';
This would be similar to "find 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" <josh(at)agliodbs(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Sent: Monday, July 23, 2001 10:32 AM
Subject: [SQL] Full-text Indexing and Primary Keys
> 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 creation. Frankly, I'm a little mystified as to why this was not
> done already, but it's not too late to correct ...
>
> -Josh
>
>
>
> ______AGLIO DATABASE SOLUTIONS___________________________
> Josh Berkus
> Complete information technology josh(at)agliodbs(dot)com
> and data management solutions (415) 565-7293
> for law firms, small businesses fax 621-2533
> and non-profit organizations. San Francisco
>
----------------------------------------------------------------------------
----
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Florian Weimer | 2001-07-23 16:56:45 | Determining if two subnets intersect |
Previous Message | Richard Huxton | 2001-07-23 15:59:18 | Re: Re: Records exactly the same. |