On Wed, 19 Mar 2003, Alvaro Herrera wrote: > On Wed, Mar 19, 2003 at 10:26:05PM +0300, Oleg Bartunov wrote: > > > we have a little problem in new version of tsearch we're currently > > working. We've implemented concatenation operation for txtidx type > > and treat concatenation with NULL as NULL (as it should be). > > But people get confused with such behaivour. Do we obliged to > > follow NULL rule ? It seems more natural in case of text searching to treat > > stringA||NULL as stringA. > > Why don't you just enclose the possibly NULL fields in COALESCE? > > stringA||COALESCE(NULL, '') >
we don't know in advance if it's NULL or not. > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(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