Re: [BUGS] comparing null value in plpgsql.

2002-03-14 Thread Tom Pfau
IL PROTECTED] Subject: Re: [BUGS] comparing null value in plpgsql. 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 conditi

Re: [BUGS] comparing null value in plpgsql.

2002-03-13 Thread bhuvanbk
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. > >

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

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

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