Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4C51A2E0257 for ; Tue, 18 Mar 2008 13:43:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 33006-09 for ; Tue, 18 Mar 2008 13:43:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web54301.mail.re2.yahoo.com (web54301.mail.re2.yahoo.com [206.190.49.111]) by postgresql.org (Postfix) with SMTP id 835412E024A for ; Tue, 18 Mar 2008 13:43:04 -0300 (ADT) Received: (qmail 51854 invoked by uid 60001); 18 Mar 2008 16:43:01 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=3/Hi72ks833upYo2CDqIrXqlbHufsU5fmdsOhllLL7FcUK2qusSqvglLPEGD8viCdSh31OWJf+ofH+wHT/bSVMkglwUK4UMN0totPhR0mnp8MjReMifnC2EFEsAZdg+sjnwBY0iwUmQSHCZBQwg84tYxHLudhGN6mBjRMoHZhFw=; X-YMail-OSG: nGd8V4MVM1mPyGpIsRHqEh91OF9zTClZdGdNxF6z4iYoXOFfSa_x3guEMn5FqsQ1K_qYf9OgFhRioWkSxZBdsI8psapLYTi2inQJdvCOwt8HjSnuBXc- Received: from [69.224.218.97] by web54301.mail.re2.yahoo.com via HTTP; Tue, 18 Mar 2008 09:43:01 PDT Date: Tue, 18 Mar 2008 09:43:01 -0700 (PDT) From: chester c young Subject: Re: Create on insert a unique random number To: "Campbell, Lance" Cc: sql pgsql In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <268179.51357.qm@web54301.mail.re2.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/101 X-Sequence-Number: 30429 > When inserting a record is there a way to have postgres create a > random number for a field such that it is unique? you could use oid ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping