| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Junkone <junkone1(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: unique key issue |
| Date: | 2006-09-19 13:49:41 |
| Message-ID: | 20060919134941.GA1789@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Sep 18, 2006 at 03:54:05PM -0700, Junkone wrote:
> HI
> I have a table with a unique key constraint on col1,col2. The dattabase
> allowed an multiple inserts. here is how
>
> col1 col2
> 'abc' <empty space>
> 'abc' <empty space>
Depends on what you mean by <empty space>. If you mean NULL, then it's
according to the SQL standard. NULL <> NULL so those rows are not
equal.
If you mean some real value, then yes, that's wierd.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthias.Pitzl | 2006-09-19 13:49:44 | Re: Access to databas from the Internet |
| Previous Message | Bill Moran | 2006-09-19 13:49:21 | Re: vista |