Re: Unknown values in int8 fields?

Have you tried "where recno IS NULL"?

----- Original Message -----
From: "Chris Ruprecht" <chrup999(at)yahoo(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
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