| From: | Roland Roberts <roland(at)astrofoto(dot)org> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Unique indices and nulls |
| Date: | 2002-09-11 17:21:28 |
| Message-ID: | m23csg1lyf.fsf@kuiper.rlent.pnet |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
>>>>> "Josh" == Josh Berkus <josh(at)agliodbs(dot)com> writes:
Josh> All DBAs are guilty of, to a lesser or greater degree, using
Josh> NULL to represent "None", even though NULL actually means
Josh> "unknown" according to the SQL spec. The rest of the SQL
Josh> spec is designed to support NULLs as "unknown", so this can
Josh> lead to problems in application. Like yours.
This is a good point, and since I know the range of values which can
go into those columns, it is easy to pick something to use as
representing "none."
roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland(at)rlenter(dot)com 76-15 113th Street, Apt 3B
roland(at)astrofoto(dot)org Forest Hills, NY 11375
| From | Date | Subject | |
|---|---|---|---|
| Next Message | reshat.sabiq.1 | 2002-09-11 17:36:39 | Changing default user's passwd |
| Previous Message | Terry Yapt | 2002-09-11 17:20:32 | Re: Strange situation with two tables. |