[BUGS] comparing null value in plpgsql.

2002-03-10 Thread Bhuvan A
hi, here i have a problem in comparing null values in plpgsql. this exist in 7.1.x and 7.2 as well. the condition != fails in plpgsql. consider this function is triggered on every updation on a table. create function ftest() returns opaque as 'declare begin if new.comp_code != ol

Re: [BUGS] comparing null value in plpgsql.

2002-03-10 Thread Stephan Szabo
On Mon, 11 Mar 2002, Bhuvan A wrote: > here i have a problem in comparing null values in plpgsql. this exist > in 7.1.x and 7.2 as well. > > the condition != fails in plpgsql. > consider this function is triggered on every updation on a table. > > create function ftest() > returns opaque as

[BUGS] Bug #611: configure script produces incorrect results under IRIX

2002-03-10 Thread pgsql-bugs
Jonathan C. Patschke ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description configure script produces incorrect results under IRIX Long Description Under IRIX (and, presumably, other commercial UNIX platforms), the configure script in

Re: [BUGS] comparing null value in plpgsql.

2002-03-10 Thread Bhuvan A
On Mar 10, Stephan Szabo wrote: > On Mon, 11 Mar 2002, Bhuvan A wrote: > > > here i have a problem in comparing null values in plpgsql. this exist > > in 7.1.x and 7.2 as well. > > > > the condition != fails in plpgsql. > > consider this function is triggered on every updation on a table. >

[BUGS] Bug #612: PostgreSQL 7.2 does not build according to documentation under IRIX w/ MIPSpro

2002-03-10 Thread pgsql-bugs
Jonathan C. Patschke ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description PostgreSQL 7.2 does not build according to documentation under IRIX w/ MIPSpro Long Description Ignore my submission about sh-vs-bash in configure. Configure

Re: [BUGS] comparing null value in plpgsql.

2002-03-10 Thread Stephan Szabo
On Mon, 11 Mar 2002, Bhuvan A wrote: > > > On Mar 10, Stephan Szabo wrote: > > > On Mon, 11 Mar 2002, Bhuvan A wrote: > > > > > here i have a problem in comparing null values in plpgsql. this exist > > > in 7.1.x and 7.2 as well. > > > > > > the condition != fails in plpgsql. > > > consider th