pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Alex Soto <alex.soto@grifols.com>
To: pgsql-admin@postgresql.org
Subject: Constraint Null Value
Date: Fri, 30 Jun 2006 16:41:57 +0200
Message-ID: <44A53835.5000202@grifols.com> (raw)

I am is Alex, and I m developing a product with PostgreSQL 8.1. I have a 
problem. This problem is that i have some unique constraints with 
multi-columns. The problem is that there is some that of the check 
constraint condition that can be null. As it is described in section 
5.3.3, null of one row is different from the null of other row, so we 
can have two entries with same values inserted because of null value is 
not a considered equal in this comparison.

Is there any administration syntax to change this behavior so null 
values are treated as same value?

Thank you very much.


La información contenida en el presente e-mail es confidencial y está reservada para el uso exclusivo de su destinatario. Se prohíbe estrictamente la distribución, copia o utilización de esta información sin el previo permiso de su destinatario. Si usted no fuera el destinatario, por favor notifíquelo inmediatamente al remitente y elimine el presente mensaje de su sistema informático.

Information contained in this e-mail is confidential and is intended for the use of the addressee only. Any dissemination, distribution, copying or use of this communication without prior permission of the addressee is strictly prohibited. If you are not the intended addressee, please notify the sender immediately by reply and then delete this message from your computer system.



view thread (2+ messages)  latest in thread

Message-ID: <44A53835.5000202@grifols.com>
Permalink:  ../44A53835.5000202@grifols.com/
Also on:    postgresql.org/message-id/44A53835.5000202@grifols.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: alex.soto@grifols.com
  Subject: Re: Constraint Null Value
  In-Reply-To: <44A53835.5000202@grifols.com>
  References: <44A53835.5000202@grifols.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox