Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 713019FB1BC for ; Fri, 3 Nov 2006 19:52:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 49129-09 for ; Fri, 3 Nov 2006 23:52:28 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 799809FA646 for ; Fri, 3 Nov 2006 19:52:28 -0400 (AST) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id 4F69D30E30; Sat, 4 Nov 2006 00:52:27 +0100 (MET) From: "Anonymous" X-Newsgroups: pgsql.sql Subject: Re: Function to reset sequence..... Date: 3 Nov 2006 15:52:20 -0800 Organization: http://groups.google.com Lines: 6 Message-ID: <1162597940.235928.118820@m73g2000cwd.googlegroups.com> References: <200610231049.16507.fluca1978@infinito.it> <001601c6f9e4$fe2d5000$6501a8c0@laptop> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com In-Reply-To: <001601c6f9e4$fe2d5000$6501a8c0@laptop> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 2.0.50727; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: m73g2000cwd.googlegroups.com; posting-host=85.102.54.30; posting-account=kJ3a-g0AAAAZNWDdqn0Vs4bplhy0zN-o To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.052 tagged_above=0 required=5 tests=BAYES_05, FORGED_HOTMAIL_RCVD2 X-Spam-Level: X-Archive-Number: 200611/73 X-Sequence-Number: 26725 It is not the answer to your question, but please note that the NATURAL JOIN may cause problems if the underlaying database structure changes (for example after a version upgrade). See the following thread for more information: http://forums.oracle.com/forums/thread.jspa?threadID=440287