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

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] -

[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 | not null default 0

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 operator. You can