return empty string from function

[Emil Obermayr]

I hope stored functions apply here es well?

I have a function that selects values from a table. If no value is found, it returns an empty string.

This function is used as column in a view.

When I use the View directly just to display some information, everything is fine.

When I try to select any available information, everything is fine as well.

But when I try to select the empty string I get an empty result set.

I tried a cast. I tried to select the empty string from a dummy record containing an empty string.

Nothing works: The empty string is not selectable in the view.

Any ideas what I am doing wrong?

PS: Returning NULL instead works nicely as well. But I really try to understand what is wrong with the empty string.