X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8DCF99FA92E for ; Fri, 30 Jun 2006 11:59:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 28769-10 for ; Fri, 30 Jun 2006 11:59:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id AE5849FA603 for ; Fri, 30 Jun 2006 11:59:25 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from frontexch1.grifols.com (smtp.grifols.com [212.31.43.105]) by svr4.postgresql.org (Postfix) with ESMTP id 01F2B5AF0AC for ; Fri, 30 Jun 2006 14:39:16 +0000 (GMT) thread-index: AcacU0wvEivPDLgVQrG0g1okFiBkQA== Received: from exch1.grifols.com ([192.168.240.1]) by frontexch1.grifols.com with Microsoft SMTPSVC(6.0.3790.2499); Fri, 30 Jun 2006 16:41:40 +0200 Received: from smtp.grifols.com ([192.168.241.2]) by exch1.grifols.com with Microsoft SMTPSVC(6.0.3790.2499); Fri, 30 Jun 2006 16:41:13 +0200 Received: from [172.17.4.106] ([172.17.4.106]) by smtp.grifols.com with ESMTP (8.9.3 (PHNE_29774)/8.7.3) id QAA12364 for ; Fri, 30 Jun 2006 16:39:13 +0200 (METDST) Message-ID: <44A53835.5000202@grifols.com> Date: Fri, 30 Jun 2006 16:41:57 +0200 From: "Alex Soto" User-Agent: Thunderbird 1.5.0.4 (X11/20060612) MIME-Version: 1.0 Content-Class: urn:content-classes:message To: X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830 Importance: normal Subject: Constraint Null Value Content-Type: text/plain; format=flowed; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable X-OriginalArrivalTime: 30 Jun 2006 14:41:13.0623 (UTC) FILETIME=[3C66DA70:01C69C53] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/281 X-Sequence-Number: 22243 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=20 multi-columns. The problem is that there is some that of the check=20 constraint condition that can be null. As it is described in section=20 5.3.3, null of one row is different from the null of other row, so we=20 can have two entries with same values inserted because of null value is=20 not a considered equal in this comparison. Is there any administration syntax to change this behavior so null=20 values are treated as same value? Thank you very much. La informaci=F3n contenida en el presente e-mail es confidencial y = est=E1 reservada para el uso exclusivo de su destinatario. Se proh=EDbe = estrictamente la distribuci=F3n, copia o utilizaci=F3n de esta = informaci=F3n sin el previo permiso de su destinatario. Si usted no = fuera el destinatario, por favor notif=EDquelo inmediatamente al = remitente y elimine el presente mensaje de su sistema inform=E1tico. 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.