[SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Rajesh Kumar Mallah
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.

2004-07-12 Thread Achilleus Mantzios
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

2004-07-12 Thread SZŰCS Gábor
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 functi

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Rajesh Kumar Mallah
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

2004-07-12 Thread Rod Taylor
On Mon, 2004-07-12 at 08:29, SZŰCS Gábor 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 o

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Achilleus Mantzios
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 > equal

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

2004-07-12 Thread Együd Csaba
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 scr

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Rajesh Kumar Mallah
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 a

Re: [SQL] Secure DB Systems - How to

2004-07-12 Thread Rajesh Kumar Mallah
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 do

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Achilleus Mantzios
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 >

[SQL] Order of execution of rules

2004-07-12 Thread Hilary Forbes
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 01689

Re: [SQL] Order of execution of rules

2004-07-12 Thread Stef
Hilary Forbes mentioned : => 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? http://www.postgresql.org/docs/7.4/static/sql-createrule.html#AEN37748 pgpgCnrDhs4Og.pgp Desc

Re: [SQL] Comparing tsearch2 vectors.

2004-07-12 Thread Rajesh Kumar Mallah
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