Have you tried "where recno IS NULL"?
----- Original Message -----
From: "Chris Ruprecht" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, July 15, 2001 7:05 PM
Subject: [SQL] Unknown values in int8 fields?
> Hi Chris,
>
> When I load records with copy <table> 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
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
