NVL vs COALESCE
When we're having an alias discussion, I'd really like to see NVL in
postgres. Not because of porting from oracle as much as just spelling
that without the reference manual is completely impossible.
Best regards,
Marcus
On Nov 24, 2005, at 21:21 , Marcus Engene wrote:
When we're having an alias discussion, I'd really like to see NVL
in postgres. Not because of porting from oracle as much as just
spelling that without the reference manual is completely impossible.
NVL: what a very unfortunate spelling. (NULL VaLue? NULL Valued
Logic? Named Very Loosely? Someone help me here :) ) AFAICT, COALESCE
is SQL standard, while NVL isn't. I think an index entry might be a
good idea.
Michael Glaesemann
grzm myrealbox com
If we're going to do that we should add IFNULL() from MySQL as well...
Chris
Michael Glaesemann wrote:
Show quoted text
On Nov 24, 2005, at 21:21 , Marcus Engene wrote:
When we're having an alias discussion, I'd really like to see NVL in
postgres. Not because of porting from oracle as much as just spelling
that without the reference manual is completely impossible.NVL: what a very unfortunate spelling. (NULL VaLue? NULL Valued Logic?
Named Very Loosely? Someone help me here :) ) AFAICT, COALESCE is SQL
standard, while NVL isn't. I think an index entry might be a good idea.Michael Glaesemann
grzm myrealbox com---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
When we're having an alias discussion, I'd really like to see NVL in
postgres. Not because of porting from oracle as much as just spelling that
without the reference manual is completely impossible.Best regards,
Marcus
You can found NVL in orafunc on pgfoundry.
Regards
Pavel Stehule
_________________________________________________________________
Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci.
http://messenger.msn.cz/
Michael Glaesemann wrote:
On Nov 24, 2005, at 21:21 , Marcus Engene wrote:
When we're having an alias discussion, I'd really like to see NVL
in postgres. Not because of porting from oracle as much as just
spelling that without the reference manual is completely impossible.NVL: what a very unfortunate spelling. (NULL VaLue? NULL Valued
Logic? Named Very Loosely? Someone help me here :) ) AFAICT, COALESCE
is SQL standard, while NVL isn't. I think an index entry might be a
good idea.
Agreed, documentation patch applied to HEAD and 8.1.X.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073