Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 761146324B1 for ; Wed, 28 Apr 2010 14:48:44 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 61380-09 for ; Wed, 28 Apr 2010 17:48:37 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-qy0-f196.google.com (mail-qy0-f196.google.com [209.85.221.196]) by mail.postgresql.org (Postfix) with ESMTP id C19976323B2 for ; Wed, 28 Apr 2010 14:48:37 -0300 (ADT) Received: by qyk34 with SMTP id 34so861514qyk.10 for ; Wed, 28 Apr 2010 10:48:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:received:in-reply-to :references:date:message-id:subject:from:to:cc:content-type; bh=GuVObN8xTjy7kUQOelggh5IBr0IIIoHuR2GL5QV/iD0=; b=kuFRVq5/5kvduzfKTJkaacS0ilEgKd5VPjYyRikC8GL2OvnScroUgmsdMPscGaa12Q DjMBPrHKqUu2BcLspxmDzD/63Y5NIYtkeBtzQX+TxYP/OqI19amLxIIveqp4mAOlpf69 r8Nm9jWo/pDsVV1yS/ZUARgkAPDXxEnM+leCw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=ZIfEQqB1hoede/LU7zNHxZZuYdSADo7NQs9danzblX/XMG0lk7Wj6kGEOeQikVL6hK 0hlRTokUlQAqd2es2YBsRmvbdNHILJfZizrCPPhGm1SO8js/opzv0+pI3QhHDefK11mh 0NHRIqTRZMD0l/gwHhJqSkl65zid3xBWq9Bmo= MIME-Version: 1.0 Received: by 10.229.96.82 with SMTP id g18mr9714195qcn.82.1272476916803; Wed, 28 Apr 2010 10:48:36 -0700 (PDT) Received: by 10.229.246.139 with HTTP; Wed, 28 Apr 2010 10:48:36 -0700 (PDT) In-Reply-To: <20335.1272474358@sss.pgh.pa.us> References: <20335.1272474358@sss.pgh.pa.us> Date: Wed, 28 Apr 2010 13:48:36 -0400 Message-ID: Subject: Re: Inserting Multiple Random Rows From: Gary Chambers To: Tom Lane Cc: pgsql-sql@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.801 tagged_above=-10 required=5 tests=BAYES_50=0.8, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201004/104 X-Sequence-Number: 34031 Tom, > I believe the sub-SELECT will only get executed once, since it has no > dependency on the outer query. That seems to be the behavior its exhibiting. > What were you expecting to happen? The clouds parting, choirs of angels singing, and fireworks celebrating the veil of my obtuseness being lifted, and my grasp and command of SQL to be complete and infinite. None of which appears will ever happen... -- Gary Chambers /* Nothing fancy and nothing Microsoft! */