[SQL] sort by relevance

[sector119]

HI, PPL!

How am I able to sort query results by relevance?
I use contrib/tsearch to search using fill text index!

-- 
WBR, sector119



msg09000/pgp0.pgp
Description: PGP signature

Re: [SQL] sort by relevance

[sector119]

On Wed, Jan 15, 2003 at 09:19:47PM +0300, Oleg Bartunov wrote:
> On Wed, 15 Jan 2003 [EMAIL PROTECTED] wrote:
> 
> > HI, PPL!
> >
> > How am I able to sort query results by relevance?
> > I use contrib/tsearch to search using fill text index!
> >
> 
> Use OpenFTS (openfts.sourceforge.net) for relevance ranking.

Am I able to use OpenFTS if I save data at db or only if I use txt files?? 

> we might add relevance feature to tsearch though.

It would be great to add this feature to tsearch! I need it so much!
Wheh we will be able to see this feature at PostgreSQL CVS? :))

-- 
WBR, sector119



msg09040/pgp0.pgp
Description: PGP signature

[SQL] connectby

[sector119]

hi

I have menu table:
 id  | integer | not null default
 nextval('public.menu_id_seq'::text)
 parent_id   | integer |
 description | text|

 I do select:
 test=> SELECT * FROM connectby('menu','id','parent_id','2',0,'~')
 t(id integer, parent_id integer, level int, branch text);

id | parent_id | level |   branch
 +---+---+-
   2 |   | 0 | 2
   4 | 2 | 1 | 2~4
   7 | 4 | 2 | 2~4~7
  10 | 7 | 3 | 2~4~7~10
  16 |10 | 4 | 2~4~7~10~16
   9 | 4 | 2 | 2~4~9

How am I able to select description file from menu table,
not only id, parent_id, level, branch fields?
  
-- 
WBR, sector119

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly