Re: [BUGS] Bug #604: string join problem

2002-02-26 Thread Erol Ozcan
Tom Lane wrote: > [EMAIL PROTECTED] writes: > > I have a major problem with string joining in sql query in Postgresql 7.1.3. It is >always return null string if any of column has null value. > > This is not a bug. SQL92 6.13 general rule 2a saith: > > a) If either S1 or S2 is the nu

Re: [BUGS] Bug #604: string join problem

2002-02-26 Thread Tom Lane
[EMAIL PROTECTED] writes: > I have a major problem with string joining in sql query in Postgresql 7.1.3. It is >always return null string if any of column has null value. This is not a bug. SQL92 6.13 general rule 2a saith: a) If either S1 or S2 is the null value, then the result o

[BUGS] Bug #604: string join problem

2002-02-26 Thread pgsql-bugs
Erol Ozcan ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description string join problem Long Description I have a major problem with string joining in sql query in Postgresql 7.1.3. It is always return null string if any of column has