Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241])
	by postgresql.org (Postfix) with ESMTP id 94263475CAF
	for <pgsql-novice@postgresql.org>; Tue, 16 Jul 2002 14:38:23 -0400 (EDT)
Received: from localhost.localdomain ([68.11.66.83]) by lakemtao04.cox.net
	(InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP
	id <20020716183825.OVGQ4949.lakemtao04.cox.net@localhost.localdomain>
	for <pgsql-novice@postgresql.org>; Tue, 16 Jul 2002 14:38:25 -0400
Subject: Re: Seeding
From: Ron Johnson <ron.l.johnson@cox.net>
To: PgSQL Novice ML <pgsql-novice@postgresql.org>
In-Reply-To: <04b301c22cee$95401a40$32021aac@chad>
References: <Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain>
	<04b301c22cee$95401a40$32021aac@chad>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.7 
Date: 16 Jul 2002 13:38:22 -0500
Message-Id: <1026844703.24332.82.camel@rebel>
Mime-Version: 1.0
X-Archive-Number: 200207/122
X-Sequence-Number: 4291

On Tue, 2002-07-16 at 12:31, Chad Thompson wrote:
> So if there is an order by in that statement and i want to insert every 2500
> records is that specific?

But you'll still have trouble, since the next time you say
ORDER BY FULL_PHONE, all of the records with FULL_PHONE='5552552555'
will all be grouped together.

What is the reason for wanting these '5552552555' records?
Maybe there is another way to skin this cat...
 
> e.g.
> create table "temp"(
> select distinct(full_phone)
> from lists
> where client_id =8
> order by full_phone)
> 
> Thanks
> Chad
> 
> ----- Original Message -----
> From: "Peter Eisentraut" <peter_e@gmx.net>
> To: "Chad Thompson" <chad@weblinkservices.com>
> Cc: "pgsql-novice" <pgsql-novice@postgresql.org>; "pgsql-sql"
> <pgsql-sql@postgresql.org>
> Sent: Monday, July 15, 2002 4:54 PM
> Subject: Re: [SQL] Seeding
> 
> 
> > Chad Thompson writes:
> >
> > > create table "temp"(
> > > select distinct(full_phone)
> > > >from lists
> > > where client_id =8)
> > >
> > > This gives me 100,000 unique records
> > >
> > > What i would like to do is, every 2500, insert a specific number like
> '5552552555'
> >
> > The first thing you're going to have to define is what you mean with
> > "every 2500", because records in tables are not ordered.

-- 
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "The greatest dangers to liberty lurk in insidious encroachment |
|  by men of zeal, well-meaning, but without understanding."      |
|   Justice Louis Brandeis, dissenting, Olmstead v US (1928)      |
+-----------------------------------------------------------------+