Re: [GENERAL] why the need for is null?

2004-01-03 Thread Gaetano Mendola
Martijn van Oosterhout wrote: On Thu, Jan 01, 2004 at 11:53:29PM +0100, Baldur Norddahl wrote: Ok, but since this can be quite annoying and unexpected, could we get an operator that does not use tristate logic but simply compares? Maybe == which seems to be free :-) So X==Y is true if X and Y are

Re: [GENERAL] website doc search is extremely SLOW

2004-01-03 Thread Joshua D. Drake
A content management system is long overdue I think, do you have any good recommendations? Bricolage -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-222-2783 - [EMAIL PROTECTED] - ht

[GENERAL] Passing a comma delimited list to a function

2004-01-03 Thread A E
Hi,   I was wondering if there was a function that handles list elements of a comma delimited list? I need to be able to pass values as a comma delimited list, count the number of values, and process the value of each.   Did not think it was very efficient to loop through the contents of the list

Re: Mnogosearch (Was: Re: [GENERAL] website doc search is ... )

2004-01-03 Thread Oleg Bartunov
On Thu, 1 Jan 2004, Marc G. Fournier wrote: > On Thu, 1 Jan 2004, Bruce Momjian wrote: > > > Marc G. Fournier wrote: > > > 186_archives=# \d ndict7 > > > Table "public.ndict7" > > > Column | Type | Modifiers > > > -+-+ > > > url_id | integer

Re: [GENERAL] website doc search is extremely SLOW

2004-01-03 Thread Oleg Bartunov
On Sat, 3 Jan 2004, Dave Cramer wrote: > On Sat, 2004-01-03 at 09:49, Oleg Bartunov wrote: > > Hi there, > > > > I hoped to release pilot version of www.pgsql.ru with full text search > > of postgresql related resources (currently we've crawled 27 sites, about > > 340K pages) but we started celebr

Re: [GENERAL] website doc search is extremely SLOW

2004-01-03 Thread Dave Cramer
On Sat, 2004-01-03 at 09:49, Oleg Bartunov wrote: > Hi there, > > I hoped to release pilot version of www.pgsql.ru with full text search > of postgresql related resources (currently we've crawled 27 sites, about > 340K pages) but we started celebration NY too early :) > Expect it tomorrow or monda

Re: [GENERAL] why the need for is null?

2004-01-03 Thread Baldur Norddahl
Quoting Guy Fraser <[EMAIL PROTECTED]>: > There already is an operator, and it is the ANSI SQL operator "IS". Just > because "IS" does not use puctuation characters does not mean it is not > an operator. "IS" is not an operator in postgresql, at least not in the same sense that "=" is an operat