Return-Path: owner-postman
Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id OAA25548 for postgres-dist; Thu, 3 Feb 1994 14:52:37 -0800
Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199402032252.OAA25548@nobozo.CS.Berkeley.EDU>
X-Authentication-Warning: nobozo.CS.Berkeley.EDU: Host localhost didn't use HELO protocol
Sender: owner-postman@postgres.Berkeley.EDU
X-Return-Path: owner-postman
Received: from relay1.UU.NET (relay1.UU.NET [192.48.96.5]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id OAA25539 for <postgres@nobozo.cs.berkeley.edu>; Thu, 3 Feb 1994 14:52:33 -0800
From: witr@rwwa.COM
Received: from spool.uu.net (via LOCALHOST) by relay1.UU.NET with SMTP 
	(5.61/UUNET-internet-primary) id AAwbsd26720; Thu, 3 Feb 94 17:52:12 -0500
Date: Thu, 3 Feb 94 17:52:12 -0500
Message-Id: <9402032252.AAwbsd26720@relay1.UU.NET>
Received: from spooky.UUCP by uucp2.uu.net with UUCP/RMAIL
	(queueing-rmail) id 175044.21512; Thu, 3 Feb 1994 17:50:44 EST
To: nobozo.CS.Berkeley.EDU!postgres@uunet.UU.NET
Subject: Re: NULL
Content-Type: text
Content-Length: 595
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Thu, 03 Feb 94 14:52:37 -0800
Resent-XMts: smtp

> 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: witr@rwwa.COM
 R.W. Withrow Associates, 21 Railroad Ave, Swampscott MA 01907-1821 USA