Hi
Is there a standard postgres method of replacing empty strings.
In Oracle, nvl handles nulls and empty strings, as does ifnull() in
MySQL, but with postgres coalesce only handles null strings.
If, not is the best solution to create a plpgsql function, ie
CREATE FUNCTION isEmpty (character
Simon Windsor wrote:
Hi
Is there a standard postgres method of replacing empty strings.
In Oracle, nvl handles nulls and empty strings, as does ifnull() in
MySQL, but with postgres coalesce only handles null strings.
If, not is the best solution to create a plpgsql function, ie
CREATE FUNCTION
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
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
Hello Robin,
giovedì, 18 giugno 98, you wrote:
RT At 12:03 PM 6/17/98 +, Jose' Soares Da Silva wrote:
Jose' Soares Da Silva writes:
SELECT name,NVL(salary)+100 AS dream FROM emp;
name |dream
---+-
Sam| 1300
Claire | 5100
Bill | 4300
At 12:03 PM 6/17/98 +, Jose' Soares Da Silva wrote:
Jose' Soares Da Silva writes:
SELECT name,NVL(salary)+100 AS dream FROM emp;
name |dream
---+-
Sam| 1300
Claire | 5100
Bill | 4300
Ginger | 4900
NULL VALUES| --- I