Hi there,

seems we'll have 7.3.4 release. Is't worth to submit new tsearch2
module for this release ? People could play with new module
without waiting 7.4 release.

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Tue, 22 Jul 2003 00:43:34 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
tsearch2 for 7.3.X

We don't normally issue new features in minor releases, but for a
/contrib, we could consider it.

---------------------------------------------------------------------------

Oleg Bartunov wrote:
> Hi there,
> 
> seems we'll have 7.3.4 release. Is't worth to submit new tsearch2
> module for this release ? People could play with new module
> without waiting 7.4 release.
> 
> 	Regards,
> 		Oleg
> _____________________________________________________________
> Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
> Sternberg Astronomical Institute, Moscow University (Russia)
> Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Mon, 21 Jul 2003 16:46:50 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: tsearch2 for 7.3.X
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Monday 21 July 2003 22:46, Bruce Momjian wrote:
> We don't normally issue new features in minor releases, but for a
> /contrib, we could consider it.
>
> ---------------------------------------------------------------------------
>
> Oleg Bartunov wrote:
> > Hi there,
> >
> > seems we'll have 7.3.4 release. Is't worth to submit new tsearch2
> > module for this release ? People could play with new module
> > without waiting 7.4 release.

FWIW: I would very much appreciate a tsearch2 for 7.3 for testing without 
having to upgrade my db's to 7.4. One question tho, is it ready for 
production? It's the ranking support which I'm looking forward to.

- -- 
Andreas Joseph Krogh <andreak@officenet.no>
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc

- - When there is no content, there is no crap.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/HFYtUopImDh2gfQRAvj8AJ90UoHrSfumA0C4wUhkzh7bzfEN0gCfVsri
NFWJfB/6ILRA6RsbMPUdcTQ=
=HvZQ
-----END PGP SIGNATURE-----

Mon, 21 Jul 2003 23:07:52 +0200
Andreas Joseph Krogh <andreak@officenet.no>
Re: tsearch2 for 7.3.X
On Mon, 21 Jul 2003, Andreas Joseph Krogh wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Monday 21 July 2003 22:46, Bruce Momjian wrote:
> > We don't normally issue new features in minor releases, but for a
> > /contrib, we could consider it.
> >
> > ---------------------------------------------------------------------------
> >
> > Oleg Bartunov wrote:
> > > Hi there,
> > >
> > > seems we'll have 7.3.4 release. Is't worth to submit new tsearch2
> > > module for this release ? People could play with new module
> > > without waiting 7.4 release.
>
> FWIW: I would very much appreciate a tsearch2 for 7.3 for testing without
> having to upgrade my db's to 7.4. One question tho, is it ready for
> production? It's the ranking support which I'm looking forward to.

I think it's production quality. Actually, we use it in our
projects with 7.3.3. You may read docs on tsearch2 home page
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

>
> - --
> Andreas Joseph Krogh <andreak@officenet.no>
> gpg public_key: http://dev.officenet.no/~andreak/public_key.asc
>
> - - When there is no content, there is no crap.
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.0.7 (GNU/Linux)
>
> iD8DBQE/HFYtUopImDh2gfQRAvj8AJ90UoHrSfumA0C4wUhkzh7bzfEN0gCfVsri
> NFWJfB/6ILRA6RsbMPUdcTQ=
> =HvZQ
> -----END PGP SIGNATURE-----
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Tue, 22 Jul 2003 01:43:02 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
Re: tsearch2 for 7.3.X
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> We don't normally issue new features in minor releases, but for a
> /contrib, we could consider it.

I can't see sticking code that hasn't been through any public beta
testing into 7.3.4.  Not even as contrib material --- how embarrassed
would you be if the contrib tree then fails to build on some platform?
7.3 is long past the point where we should be adding new features to it.

If there are people out there who want to try tsearch2 with 7.3,
let them grab a separate tarball for it.

			regards, tom lane

Tue, 22 Jul 2003 00:29:46 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: tsearch2 for 7.3.X 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Monday 21 July 2003 23:43, Oleg Bartunov wrote:
> On Mon, 21 Jul 2003, Andreas Joseph Krogh wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > On Monday 21 July 2003 22:46, Bruce Momjian wrote:
> > > We don't normally issue new features in minor releases, but for a
> > > /contrib, we could consider it.
> > >
> > > -----------------------------------------------------------------------
> > >----
> > >
> > > Oleg Bartunov wrote:
> > > > Hi there,
> > > >
> > > > seems we'll have 7.3.4 release. Is't worth to submit new tsearch2
> > > > module for this release ? People could play with new module
> > > > without waiting 7.4 release.
> >
> > FWIW: I would very much appreciate a tsearch2 for 7.3 for testing without
> > having to upgrade my db's to 7.4. One question tho, is it ready for
> > production? It's the ranking support which I'm looking forward to.
>
> I think it's production quality. Actually, we use it in our
> projects with 7.3.3. You may read docs on tsearch2 home page
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

I've read it, and it looks promissing, good work!

- -- 
Andreas Joseph Krogh <andreak@officenet.no>
gpg public_key: http://dev.officenet.no/~andreak/public_key.asc

- - When there is no content, there is no crap.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE/HNvwUopImDh2gfQRAgvHAKCdmf2eNUvjsUx0Xw6ARNDoEEI9dQCeIvWg
KdACyIa6jckNeu9MlHn4DLQ=
=ge1g
-----END PGP SIGNATURE-----

Tue, 22 Jul 2003 08:38:33 +0200
Andreas Joseph Krogh <andreak@officenet.no>
Re: tsearch2 for 7.3.X
OK. I'll suggest people to try new tsearch2 in README file of old
tsearch.

	Oleg
On Tue, 22 Jul 2003, Tom Lane wrote:

> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > We don't normally issue new features in minor releases, but for a
> > /contrib, we could consider it.
>
> I can't see sticking code that hasn't been through any public beta
> testing into 7.3.4.  Not even as contrib material --- how embarrassed
> would you be if the contrib tree then fails to build on some platform?
> 7.3 is long past the point where we should be adding new features to it.
>
> If there are people out there who want to try tsearch2 with 7.3,
> let them grab a separate tarball for it.
>
> 			regards, tom lane
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Tue, 22 Jul 2003 10:48:43 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
Re: tsearch2 for 7.3.X 
> I think it's production quality. Actually, we use it in our
> projects with 7.3.3. You may read docs on tsearch2 home page
> http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

You know what would be an AWESOME feature? The ability to process user
queries directly:

eg.

SELECT intindex, strtopic FROM tblmessages
                                  WHERE idxfti @@ 'jam and
toast -guitar'::userquery::tsquery;

Or be able to understand stuff like:

'jam and toast or (jam -guitar)

etc., etc.

Chris



Tue, 22 Jul 2003 15:03:40 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: tsearch2 for 7.3.X


Christopher Kings-Lynne wrote:
>>I think it's production quality. Actually, we use it in our
>>projects with 7.3.3. You may read docs on tsearch2 home page
>>http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
> 
> 
> You know what would be an AWESOME feature? The ability to process user
> queries directly:
> 
> eg.
> 
> SELECT intindex, strtopic FROM tblmessages
>                                   WHERE idxfti @@ 'jam and
> toast -guitar'::userquery::tsquery;

idxfti @@ 'jam & toast & ! guitar'


> 
> Or be able to understand stuff like:
> 
> 'jam and toast or (jam -guitar)

'(jam & toast) | ( jam & !guitar )'


Sintax of query is boolean expression. Look at 'The tsearch2 Guide' 
(http://rhodesmill.org/brandon/projects/tsearch2-guide.html).

-- 
Teodor Sigaev                                  E-mail: teodor@sigaev.ru


Tue, 22 Jul 2003 13:38:53 +0400
Teodor Sigaev <teodor@sigaev.ru>
Re: tsearch2 for 7.3.X
Oleg Bartunov <oleg@sai.msu.su> writes:
> OK. I'll suggest people to try new tsearch2 in README file of old
> tsearch.

Okay, that works for me.  Please patch the old tsearch README file in
both HEAD and REL7_3_STABLE branch as soon as possible --- we are going
to wrap a 7.3.4 release as soon as Bruce finds the time to make release
notes, possibly today.

			regards, tom lane

Tue, 22 Jul 2003 09:40:12 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: tsearch2 for 7.3.X 
On Tue, 22 Jul 2003, Tom Lane wrote:

> Oleg Bartunov <oleg@sai.msu.su> writes:
> > OK. I'll suggest people to try new tsearch2 in README file of old
> > tsearch.
> 
> Okay, that works for me.  Please patch the old tsearch README file in
> both HEAD and REL7_3_STABLE branch as soon as possible --- we are going
> to wrap a 7.3.4 release as soon as Bruce finds the time to make release
> notes, possibly today.

I don't expect you wouldn't put in the information but just to highlight that
it'd be a good idea to put the location the tsearch2 tarball can picked up from
in the README.


--
Nigel Andrews



Tue, 22 Jul 2003 16:10:01 +0100 (BST)
"Nigel J. Andrews" <nandrews@investsystems.co.uk>
Re: tsearch2 for 7.3.X
Patched.

Tom Lane wrote:
> Oleg Bartunov <oleg@sai.msu.su> writes:
> 
>>OK. I'll suggest people to try new tsearch2 in README file of old
>>tsearch.
> 
> 
> Okay, that works for me.  Please patch the old tsearch README file in
> both HEAD and REL7_3_STABLE branch as soon as possible --- we are going
> to wrap a 7.3.4 release as soon as Bruce finds the time to make release
> notes, possibly today.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match

-- 
Teodor Sigaev                                  E-mail: teodor@sigaev.ru


Tue, 22 Jul 2003 20:01:31 +0400
Teodor Sigaev <teodor@sigaev.ru>
Re: tsearch2 for 7.3.X
Tom Lane wrote:
> Oleg Bartunov <oleg@sai.msu.su> writes:
> > OK. I'll suggest people to try new tsearch2 in README file of old
> > tsearch.
> 
> Okay, that works for me.  Please patch the old tsearch README file in
> both HEAD and REL7_3_STABLE branch as soon as possible --- we are going
> to wrap a 7.3.4 release as soon as Bruce finds the time to make release
> notes, possibly today.

Yes, today.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Tue, 22 Jul 2003 12:05:35 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: tsearch2 for 7.3.X
> > SELECT intindex, strtopic FROM tblmessages
> >                                   WHERE idxfti @@ 'jam and
> > toast -guitar'::userquery::tsquery;
>
> idxfti @@ 'jam & toast & ! guitar'

I mean, the end user - the person entering the search string on the website
won't know that syntax...

Chris


Wed, 23 Jul 2003 09:17:28 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: tsearch2 for 7.3.X
On Wed, 23 Jul 2003, Christopher Kings-Lynne wrote:

> > > SELECT intindex, strtopic FROM tblmessages
> > >                                   WHERE idxfti @@ 'jam and
> > > toast -guitar'::userquery::tsquery;
> >
> > idxfti @@ 'jam & toast & ! guitar'
>
> I mean, the end user - the person entering the search string on the website
> won't know that syntax...

You always could rewrite user query to that syntax.

>
> Chris
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Wed, 23 Jul 2003 08:05:10 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
Re: tsearch2 for 7.3.X
> > I mean, the end user - the person entering the search string on the
website
> > won't know that syntax...
>
> You always could rewrite user query to that syntax.

That's why I said it would be a cool feature!  Saves every web designer from
writing the conversion code for their site - you just provide a function to
do it...

Chris


Wed, 23 Jul 2003 12:11:26 +0800
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au>
Re: tsearch2 for 7.3.X
On Wed, 23 Jul 2003, Christopher Kings-Lynne wrote:

> > > I mean, the end user - the person entering the search string on the
> website
> > > won't know that syntax...
> >
> > You always could rewrite user query to that syntax.
>
> That's why I said it would be a cool feature!  Saves every web designer from
> writing the conversion code for their site - you just provide a function to
> do it...

feel free to write such conversion fuction and share with us.
The problem is that there are many user oriented query languages and
it's difficult to recognize which conversion funcion to use.

>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>

	Regards,
		Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Wed, 23 Jul 2003 08:16:52 +0400 (MSD)
Oleg Bartunov <oleg@sai.msu.su>
Re: tsearch2 for 7.3.X