Received: from utahisp.com (www.cyber-wire.com [209.119.76.3])
	by postgresql.org (Postfix) with ESMTP id D0710474E42
	for <pgsql-novice@postgresql.org>; Tue, 16 Jul 2002 13:31:02 -0400 (EDT)
Received: from chad [63.230.8.76] by utahisp.com
	(SMTPD32-5.05) id A74122570078; Tue, 16 Jul 2002 11:26:25 -0600
Message-ID: <04b301c22cee$95401a40$32021aac@chad>
From: "Chad Thompson" <chad@weblinkservices.com>
To: "Peter Eisentraut" <peter_e@gmx.net>
Cc: "pgsql-novice" <pgsql-novice@postgresql.org>
References: <Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain>
Subject: Re: Seeding
Date: Tue, 16 Jul 2002 11:31:12 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
X-Archive-Number: 200207/121
X-Sequence-Number: 4290

So if there is an order by in that statement and i want to insert every 2500
records is that specific?

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.
>
> --
> Peter Eisentraut   peter_e@gmx.net
>
>