Subject: Re: NULL

From: [email-masked]
Date: Thu, 3 Feb 94 17:52:12 -0500

> It isn't clear from the POSTGRES documentation how 'NULL' is supposed
> to be expressed.

  Feed to monitor:

create FOO(
  frabble=text,
  frebble=text,
  fribble=int4,
  frobble=int4
) archive=none
\g

append FOO( 
  frabble="I'm text",
  frebble="So am I",
  fribble=42,
  frobble="-1"
)
\g

retrieve (FOO.all)
\g

replace FOO( 
  frebble=NULL,
  frobble=NULL
) where FOO.frabble="I'm text"
\g

retrieve (FOO.all)
\g

destroy FOO
\g

---
 Robert Withrow, Tel: +1 617 598 4480, Fax: +1 617 598 4430, Net: [email-masked]
 R.W. Withrow Associates, 21 Railroad Ave, Swampscott MA 01907-1821 USA