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 - bus
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 the
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
