Re: [HACKERS] NULL OR ZERO

2008-02-06 Thread Rodrigo E. De León Plicet
On Feb 3, 2008 7:41 PM, Jaime Casanova [EMAIL PROTECTED] wrote: On Feb 3, 2008 7:26 PM, Omar Bettin [EMAIL PROTECTED] wrote: Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO. I know about standards... NULL means unknown value, ZERO is a known value NULL

Re: [HACKERS] NULL OR ZERO

2008-02-04 Thread Andrei Kovalevski
Hello, Omar Bettin wrote: Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO. I know about standards... You can easily convert NULLs to 0 in your queries - read about COALESCE function http://www.postgresql.org/docs/8.0/interactive/functions-conditional.html.

Re: [HACKERS] NULL OR ZERO

2008-02-03 Thread Jaime Casanova
On Feb 3, 2008 7:26 PM, Omar Bettin [EMAIL PROTECTED] wrote: Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO. I know about standards... NULL means unknown value, ZERO is a known value -- regards, Jaime Casanova Programming today is a race between software

[HACKERS] NULL OR ZERO

2008-02-03 Thread Omar Bettin
Probably I am on the wrong place but for me NULL on numbers means 0 or ZERO. I know about standards... but I think that integralism is somewhat wrong. Omar a programmer... ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will