Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 91FCA2E0180 for ; Tue, 18 Mar 2008 14:32:17 -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 43371-09 for ; Tue, 18 Mar 2008 14:32:12 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.181]) by postgresql.org (Postfix) with ESMTP id C74DB2E01A1 for ; Tue, 18 Mar 2008 14:32:12 -0300 (ADT) Received: by el-out-1112.google.com with SMTP id z25so7759ele.0 for ; Tue, 18 Mar 2008 10:32:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; bh=zXHOPDQ0Q+KALMHF84DtJvpiKeTkFFhSg4t5ubq1Dbo=; b=qzTpyL3HHeZQ1kEKQ795P8rO80MDrZO1tv8FUuHgp02r6H70NDTVAgaK5Q5aiPSd873nOJQPWhQerPyKZc6gknqUeCrcB17uEImSbBQo3kFz62wRoz43vU4rW4uTWqSwoDMFBHlNYVlZ20ZFjovS6GxtSrmOHOp8ySPb1X/FU/Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=ZH4P3rgE9FdFS8UoXiiMPIvJx+6rqPatGp1AqSyeIpFQwMrT34W1Rji8eT02NXitsVa653qZxEDXUdw73lZJTqNA7R4iHRfcxsNJYBu1itoTi3HItqu9SKUsKUTyAn0V7vcDV9aATTz1W0FvyeZgREgZHDWqj6UsGNv35FME2GE= Received: by 10.115.110.6 with SMTP id n6mr2084632wam.92.1205861530996; Tue, 18 Mar 2008 10:32:10 -0700 (PDT) Received: from ?169.229.240.211? ( [169.229.240.211]) by mx.google.com with ESMTPS id v35sm4944327wah.19.2008.03.18.10.32.09 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 18 Mar 2008 10:32:10 -0700 (PDT) Message-ID: <47DFFCE9.8000307@gmail.com> Date: Tue, 18 Mar 2008 10:33:29 -0700 From: paul rivers User-Agent: Thunderbird 2.0.0.12 (X11/20080227) MIME-Version: 1.0 To: "Campbell, Lance" CC: "A. Kretschmer" , pgsql-sql@postgresql.org Subject: Re: Create on insert a unique random number References: <268179.51357.qm@web54301.mail.re2.yahoo.com> <20080318165138.GA6578@a-kretschmer.de> In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/104 X-Sequence-Number: 30432 Campbell, Lance wrote: > 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? > > Thanks, > > > Why do you want a random number? Would a guid work? Paul