| Lists: | pgsql-docs |
|---|
| From: | David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Documenting NULLVALUE() and NONNULLVALUE() |
| Date: | 2004-08-07 14:08:36 |
| Message-ID: | 4114E264.2090709@zara.6.isreserved.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
Perl and PHP programmers (such as myself) are accustomed to using
defined()/isset() and so when wanting to test null value they might look
to the Functions chapter (9) instead of the SQL Syntax chapter (4). It
took me some time before I found out about ISNULL, IS NULL, NOTNULL, IS
NOT NULL. In MySQL I am accustomed to using ISNULL() function.
Perhaps we can change section 9.1 from "Logical Operators" to "Logical
Functions and Operators"? NULLVALUE() and NONNULLVALUE() can be
documented there, along with IS, IS NULL, and IS NOT NULL (which also
don't seem to have been covered yet in Chapter 9).
Should I submit a patch?
--
dave
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: Documenting NULLVALUE() and NONNULLVALUE() |
| Date: | 2004-08-07 17:01:10 |
| Message-ID: | 549.1091898070@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> writes:
> Perhaps we can change section 9.1 from "Logical Operators" to "Logical
> Functions and Operators"? NULLVALUE() and NONNULLVALUE() can be
> documented there, along with IS, IS NULL, and IS NOT NULL (which also
> don't seem to have been covered yet in Chapter 9).
I don't think we should document nullvalue() and nonnullvalue(), because
they are not standard.
As for "not covered", IS NULL is documented in 9.2 Comparison Operators.
regards, tom lane
| From: | David Garamond <lists(at)zara(dot)6(dot)isreserved(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: Documenting NULLVALUE() and NONNULLVALUE() |
| Date: | 2004-08-07 19:57:07 |
| Message-ID: | 41153413.2050608@zara.6.isreserved.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-docs |
Tom Lane wrote:
>>Perhaps we can change section 9.1 from "Logical Operators" to "Logical
>>Functions and Operators"? NULLVALUE() and NONNULLVALUE() can be
>>documented there, along with IS, IS NULL, and IS NOT NULL (which also
>>don't seem to have been covered yet in Chapter 9).
>
> I don't think we should document nullvalue() and nonnullvalue(), because
> they are not standard.
>
> As for "not covered", IS NULL is documented in 9.2 Comparison Operators.
Ah, it's not immediately visible so I missed that. Thanks.
--
dave