Received: from smtp016.mail.yahoo.com (smtp016.mail.yahoo.com [216.136.174.113]) by postgresql.org (8.11.3/8.11.1) with SMTP id f6G3bna35157 for ; Sun, 15 Jul 2001 23:37:49 -0400 (EDT) (envelope-from acroyear_07030@yahoo.com) Received: from adsl-63-202-90-251.dsl.snfc21.pacbell.net (HELO Steph1) (63.202.90.251) by smtp.mail.vip.sc5.yahoo.com with SMTP; 16 Jul 2001 03:37:43 -0000 X-Apparently-From: Message-ID: <005001c10daa$318c1530$6fde010a@myst.com> From: "Stephan Szabo" To: "Chris Ruprecht" Cc: References: Subject: Re: Unknown values in int8 fields? Date: Sun, 15 Jul 2001 20:48:32 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-Mimeole: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200107/195 X-Sequence-Number: 3990 Have you tried "where recno IS NULL"? ----- Original Message ----- From: "Chris Ruprecht" To: Sent: Sunday, July 15, 2001 7:05 PM Subject: [SQL] Unknown values in int8 fields? > Hi Chris, > > When I load records with copy from ... And one of the fields (last > one) is left empty, I want the default of nextval('sequence_table') to kick > in - but it doesn't. > Now, the field with a unique index on it stays blank. No big deal if I could > go and say 'update rate set recno = nextval('sequence_rate') where recno = 0 > - but it's not that easy as the recno is not 0 but - hmm what? What can I > check for? I tried '?' and ? And 0 and ... And ... And ... But nothing works > ... Now what? _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com