Hi,
This time I think this is a bug, but where? In my code or in plpgsql? Or
in my understanding of dynamic queries?
If the following is executed in context, where the dynamic query returns
data with every iteration everythin goes fine. If the the dynamic query
returns nothing - bush becomes
Mauri Sahlberg [EMAIL PROTECTED] writes:
If the following is executed in context, where the dynamic query returns
data with every iteration everythin goes fine. If the the dynamic query
returns nothing - bush becomes null and everything fails. I do not
undestand why bush becomes null when the
Concatenating a null value makes the string null. try:
SELECT 'foo'||NULL||'bar';
Just add a condition to check rivi.suoritus for null before making an
assignment.
Mauri Sahlberg wrote:
returns nothing - bush becomes null and everything fails. I do not
undestand why bush becomes null when
On Thu, 28 Aug 2003, Josh Goldberg wrote:
Concatenating a null value makes the string null. try:
SELECT 'foo'||NULL||'bar';
Just add a condition to check rivi.suoritus for null before making an
assignment.
or better use coalesce
Mauri Sahlberg wrote:
returns nothing - bush becomes