Andreas Joseph Krogh wrote: > Why do these discussions always end in academic arguments over whats more > logical then not? From a *user's* point of view I really would like it to > treat the NULL operand of || as '', and obviously many other (at least > Oracle) users tend to agree with me on that.
So coalesce the column to the empty string if that's what you want: select coalesce(NULL, '') || 'fisk' will get you 'fisk'. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
