Simon Windsor <[EMAIL PROTECTED]> writes: > Hi > > I understand that null and '' are different, and MySQL and Oracle > functions are confusing, but my question was not about replacing NULL > but replacing Empty strings. These are handled in MySQL/Oracle by the > same functions that do NULL checks. > > Is there a standard function in Postgres that replaces Empty strings, as > against a NULL value.
I don't think so, but you could use a CASE clause for this. -Doug ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])