Re: 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(at)gmx(dot)net>
> To: "Chad Thompson" <chad(at)weblinkservices(dot)com>
> Cc: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>; "pgsql-sql"
> <pgsql-sql(at)postgresql(dot)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(dot)l(dot)johnson(at)cox(dot)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) |
+-----------------------------------------------------------------+