Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 09A7B2E0085 for ; Mon, 2 Jun 2008 16:19:22 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 35218-05 for ; Mon, 2 Jun 2008 16:19:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from gwmta.wicourts.gov (gwmta.wicourts.gov [165.219.244.99]) by developer.postgresql.org (Postfix) with ESMTP id 267DC2E003B for ; Mon, 2 Jun 2008 16:19:15 -0300 (ADT) Received: from Courts-MTA by gwmta.wicourts.gov with Novell_GroupWise; Mon, 02 Jun 2008 14:19:13 -0500 Message-Id: <484401E9.EE98.0025.0@wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 7.0.3 Date: Mon, 02 Jun 2008 14:19:05 -0500 From: "Kevin Grittner" To: "Gordon Hyatt" , Subject: Re: UUID generation functions References: <85AC2B55AEF4CC41A2145B60C7F88074026535@JDCMAIL4.joslin.harvard.edu> In-Reply-To: <85AC2B55AEF4CC41A2145B60C7F88074026535@JDCMAIL4.joslin.harvard.edu> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200806/8 X-Sequence-Number: 29346 >>> On Mon, Jun 2, 2008 at 1:52 PM, in message <85AC2B55AEF4CC41A2145B60C7F88074026535@JDCMAIL4.joslin.harvard.edu>, "Hyatt, Gordon" wrote: > does anyone know if there are any internal > UUID generation functions in pg? I took a quick look at the 8.2 docs > and didn't find anything related. Any chance of going to 8.3? http://www.postgresql.org/docs/8.3/interactive/datatype-uuid.html -Kevin