Received: from bubba.NMSU.Edu (bubba.NMSU.Edu [128.123.3.39]) by hub.org (8.8.8/8.7.5) with ESMTP id OAA07016; Thu, 23 Jul 1998 14:50:25 -0400 (EDT) Received: from dns1.NMSU.Edu (dns1.NMSU.Edu [128.123.3.5]) by bubba.NMSU.Edu (8.9.0/8.9.0) with ESMTP id MAA00295; Thu, 23 Jul 1998 12:50:59 -0600 (MDT) Received: from wilma.NMSU.Edu (wilma.NMSU.Edu [128.123.3.12]) by dns1.NMSU.Edu (8.9.0/8.9.0) with ESMTP id MAA24291; Thu, 23 Jul 1998 12:50:19 -0600 (MDT) Received: from localhost (lorenzo@localhost) by wilma.NMSU.Edu (8.9.0/8.9.0) with SMTP id MAA09462; Thu, 23 Jul 1998 12:50:17 -0600 (MDT) X-Authentication-Warning: wilma.NMSU.Edu: lorenzo owned process doing -bs Date: Thu, 23 Jul 1998 12:50:17 -0600 (MDT) From: Lorenzo Huerta X-Sender: lorenzo@wilma To: pgsql-sql@postgreSQL.org cc: pgsql-general@postgreSQL.org Subject: help with uniq index Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII is there a way to create a unique index on a field (in ver 6.3.1 )and also have a single non-uniq value in that value, ie the NULL value? Thanks, __________________________________________________________________ * Lorenzo J. Huerta * * Programming Assistant * * Computing & Networking Networking Architecture and Operations * * New Mexico State University * * phone: (w)(505)646-2582 (h)(505) 521-8699 fax:(505) 646-8139 * * e-mail: lorenzo@nmsu.edu * * Web Site: http://web.nmsu.edu/~ljhuerta * __________________________________________________________________