[SQL] Comparing tsearch2 vectors.

Hi, We want to compare strings after stemming. Can anyone tell me what is the best method. I was thinking to compare the tsvector ,but there is no operator for that. Regds Mallah. tradein_clients=# SELECT to_tsvector('handicraft exporters'); +---+ |to_tsvector

Re: [SQL] Comparing tsearch2 vectors.

O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : Hi, We want to compare strings after stemming. Can anyone tell me what is the best method. I was thinking to compare the tsvector ,but there is no operator for that. I'd tokenize each string and then apply lexize() to get the

Re: [SQL] Constraint-function dependency and dump in 7.3

Dear Fellow Countymen, I fear none of your answers are acceptable for me. Also, from Csaba's answer, this sounds to me more like a bug in pg_dump v7.3. (1) I wish to transfer the full dump for daily mirroring. Thus, data-only isn't an option. (2) Dumping functions first won't work for SQL

Re: [SQL] Comparing tsearch2 vectors.

Dear Mantzios, I have to get set of banners from database in response to a search term. I want that the search term be compared to the keyword corresponding to the banners stored in database. current i am doing an equality match but i woild like to do it after stemming both the sides (serch term

Re: [SQL] Constraint-function dependency and dump in 7.3

On Mon, 2004-07-12 at 08:29, SZCS Gbor wrote: Dear Fellow Countymen, I fear none of your answers are acceptable for me. Also, from Csaba's answer, this sounds to me more like a bug in pg_dump v7.3. It is a bug (or a missing feature) that should be solved with v7.5 for restoring to 7.5 or

Re: [SQL] Comparing tsearch2 vectors.

O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : Dear Mantzios, I have to get set of banners from database in response to a search term. I want that the search term be compared to the keyword corresponding to the banners stored in database. current i am doing an equality

Re: [SQL] Constraint-function dependency and dump in 7.3

Dear Gabor, I meant that if the schema of the given database is not altered frequently it can be a considerable solution keeping the schema in a separate file. When it is altered you must make a new one, but just once per schema modifications. I don't think that it is a painful thing to write a

Re: [SQL] Comparing tsearch2 vectors.

Achilleus Mantzios wrote: O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : Dear Mantzios, I have to get set of banners from database in response to a search term. I want that the search term be compared to the keyword corresponding to the banners stored in database. current i am doing

Re: [SQL] Secure DB Systems - How to

Sarah Tanembaum wrote: I was wondering if it is possible to create a secure database system usingPostgreSQL/PHP combination? I have the following in mind: I wanted to store all my( and my brothers and sisters) important document information such as birth certificate, SSN, passport number, travel

Re: [SQL] Comparing tsearch2 vectors.

O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : Achilleus Mantzios wrote: O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : Dear Mantzios, I have to get set of banners from database in response to a search term. I want that the search term be compared to the

[SQL] Order of execution of rules

Can I guarantee that if I have more than one Rule on a table they will be executed in a given order? I know triggers are done alphabetically but is the same true of rules? Many thanks Hilary Hilary Forbes The DMR Information and Technology Group (www.dmr.co.uk) Direct tel 01689 889950 Fax

Re: [SQL] Comparing tsearch2 vectors.

Achilleus Mantzios wrote: O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : Achilleus Mantzios wrote: O kyrios Rajesh Kumar Mallah egrapse stis Jul 12, 2004 : Dear Mantzios, I have to get set of banners from database in response to a search term. I want that the search term