Skip site navigation (1) Skip section navigation (2)

Re: Seeding

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Seeding
Date: 2002-07-16 18:38:22
Message-ID: 1026844703.24332.82.camel@rebel (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-sql
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)      |
+-----------------------------------------------------------------+


In response to

  • Re: Seeding at 2002-07-16 17:31:12 from Chad Thompson

Responses

  • Re: Seeding at 2002-07-16 19:38:59 from Chad Thompson

pgsql-novice by date

Next:From: Søren NeigaardDate: 2002-07-16 18:43:57
Subject: How do only allow one group access to my database
Previous:From: Chad ThompsonDate: 2002-07-16 17:31:12
Subject: Re: Seeding

pgsql-sql by date

Next:From: Stephan SzaboDate: 2002-07-16 18:52:05
Subject: Re: Need help on a troublesome query plan
Previous:From: Josh BerkusDate: 2002-07-16 18:07:22
Subject: Re: A SQL Training

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group