On Tue, Feb 25, 2003 at 15:25:17 +0100, Natasa Bulatovic <[EMAIL PROTECTED]> wrote: > > select col1||col2||col3||.....||col100 from table > > Most of these columns for the test data are NULL...Datatypes of columns are mixed > text, varchar, char...Select statement does not return any error...Just returns a > row with a null result....
If you concatenate null with another string you get null, not the other string. You need to use coalesce to convert nulls to empty strings. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
