Horton

RE: Concat error in PL/pgsql

Andrew Snow <andrew@modulus.org>

View thread
From: "Andrew Snow" <andrew@modulus.org>
To: <pgsql-bugs@postgresql.org>
Date: 2001-01-07T08:51:51Z
Lists: pgsql-bugs 
A few hours ago, I wrote:
> 
> Simple add lines as shown:
> 
> > 	for r in select * from tconcattest loop
> 		IF r.str IS NOT NULL THEN
> > 			output := output || r.str;			
> 		END IF;
> > 	end loop;
> 


This would probably be better:

	for r in select * from tconcattest where str is not null loop
		output := output || r.str;			
	end loop;