drop table foo;
create table foo (x,y,z);
insert into foo values (1, null, null);
insert into foo values (2, null, null);
insert into foo values (3, 33, 333);
select x ||  "-" || y ||  "-" || z from foo;

whe I run the above select I only see the last row.

it looks as if a row has any nulls in the concatenation then all the values are suppressed.


is this the correct behavior?




Reply via email to