public inbox for [email protected]  

help / color / mirror / Atom feed

Documenting NULLVALUE() and NONNULLVALUE()
3+ messages / 2 participants
[nested] [flat]

* Documenting NULLVALUE() and NONNULLVALUE()
@ 2004-08-07 14:08  David Garamond <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: David Garamond @ 2004-08-07 14:08 UTC (permalink / raw)
  To: 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Documenting NULLVALUE() and NONNULLVALUE()
@ 2004-08-07 17:01  Tom Lane <[email protected]>
  parent: David Garamond <[email protected]>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2004-08-07 17:01 UTC (permalink / raw)
  To: David Garamond <[email protected]>; +Cc: pgsql-docs

David Garamond <[email protected]> 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Documenting NULLVALUE() and NONNULLVALUE()
@ 2004-08-07 19:57  David Garamond <[email protected]>
  parent: Tom Lane <[email protected]>
  0 siblings, 0 replies; 3+ messages in thread

From: David Garamond @ 2004-08-07 19:57 UTC (permalink / raw)
  To: Tom Lane <[email protected]>; +Cc: 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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2004-08-07 19:57 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-08-07 14:08 Documenting NULLVALUE() and NONNULLVALUE() David Garamond <[email protected]>
2004-08-07 17:01 ` Tom Lane <[email protected]>
2004-08-07 19:57   ` David Garamond <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox