Skip site navigation (1) Skip section navigation (2)

RE: Concat error in PL/pgsql

From: "Andrew Snow" <andrew(at)modulus(dot)org>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: RE: Concat error in PL/pgsql
Date: 2001-01-07 08:51:51
Message-ID: JEEGIJPOJIGGIIHGKOKOCEMACHAA.andrew@modulus.org (view raw or flat)
Thread:
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;




In response to

pgsql-bugs by date

Next:From: sminneDate: 2001-01-08 10:36:38
Subject: Sequence of characters not supported by psql/pg_dump
Previous:From: Andrew SnowDate: 2001-01-07 00:57:55
Subject: RE: Concat error in PL/pgsql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group