Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 213782E01A1 for ; Tue, 18 Mar 2008 14:57:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 10105-06 for ; Tue, 18 Mar 2008 14:57:42 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.171]) by postgresql.org (Postfix) with ESMTP id 40FE52E0179 for ; Tue, 18 Mar 2008 14:57:42 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu8) with ESMTP (Nemesis) id 0ML31I-1Jbg4C3Sje-0001Pg; Tue, 18 Mar 2008 18:57:41 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1Jbg4C-00020W-00 for pgsql-sql@postgresql.org; Tue, 18 Mar 2008 18:57:40 +0100 Date: Tue, 18 Mar 2008 18:57:40 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Create on insert a unique random number Message-ID: <20080318175740.GA7657@a-kretschmer.de> References: <268179.51357.qm@web54301.mail.re2.yahoo.com> <20080318165138.GA6578@a-kretschmer.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1/3vKsoXLjkfQhHiIz51WRVghAzC4yRZ8TBalf 9VOmpOBJZmsE2rLcXrMd4ZTmHI7K86syCCu2F5wEFY19S8qNab I3AfS/lJtjtJSX3Ex5ojbd1LPRA7+xq X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/107 X-Sequence-Number: 30435 am Tue, dem 18.03.2008, um 12:03:31 -0500 mailte Campbell, Lance folgendes: > I created the following table: > > create table xyz ( > n serial, > abc character varying, > constraint n_pkey primary key (n)); > > Each time I do an insert: > > insert into xyz(abc) values('adf6'); > > The field n is not random but is sequential. Is there something I > should do to make the serial number random? Why do you mean to need a random value? But you can use something like md5(nextval('your_sequence')) as default. But i can't see an advantage. > > > -----Original Message----- Please, no top-posting. I'm reading from top to bottom. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net