Re: Using NULL values in calculated results

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zak McGregor <zak(at)mighty(dot)co(dot)za>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Using NULL values in calculated results
Date: 2001-02-23 15:42:34
Message-ID: 28031.982942954@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zak McGregor <zak(at)mighty(dot)co(dot)za> writes:
> but select 1/null => division by zero error. Is this how it is supposed to
> work?

Nope. It's fixed for 7.1.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Jones 2001-02-23 16:03:16 Re: is this expected or am i on crack?
Previous Message Louis-David Mitterrand 2001-02-23 15:41:31 Re: UNIQUE constraint fails