Message-ID: <050d01c22d00$6f2a5390$32021aac@chad>
From: "Chad Thompson" <chad@weblinkservices.com>
To: "Ron Johnson" <ron.l.johnson@cox.net>,
	"pgsql-novice" <pgsql-novice@postgresql.org>
References: <Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain>
	<04b301c22cee$95401a40$32021aac@chad>
	<1026844703.24332.82.camel@rebel>
Subject: Re: Seeding
Date: Tue, 16 Jul 2002 13:38:59 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I feed this list into a 3rd party dialer.  My objective is to try to have my
number or the clients number called during the running of the project.  I
need the list to be generated from the database so the results of the
project will be submitted to the database.  (if i generate a text file to
feed to the dialer the results only show up in a text file.)

Thanks
Chad
----- Original Message -----
From: "Ron Johnson" <ron.l.johnson@cox.net>
To: "PgSQL Novice ML" <pgsql-novice@postgresql.org>
Sent: Tuesday, July 16, 2002 12:38 PM
Subject: Re: [NOVICE] Seeding


> 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)      |
> +-----------------------------------------------------------------+
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>