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

Re: Seeding

From: "Chad Thompson" <chad(at)weblinkservices(dot)com>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Seeding
Date: 2002-07-16 17:31:12
Message-ID: 04b301c22cee$95401a40$32021aac@chad (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-sql
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(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.
>
> --
> Peter Eisentraut   peter_e(at)gmx(dot)net
>
>


In response to

Responses

  • Re: Seeding at 2002-07-16 18:38:22 from Ron Johnson
  • Re: Seeding at 2002-07-17 22:33:07 from Peter Eisentraut

pgsql-novice by date

Next:From: Ron JohnsonDate: 2002-07-16 18:38:22
Subject: Re: Seeding
Previous:From: Jim MorcombeDate: 2002-07-16 03:59:57
Subject: Problems linking to libpq

pgsql-sql by date

Next:From: Kevin BrannenDate: 2002-07-16 17:37:04
Subject: datatype matrix (was: Re: Sorry..)
Previous:From: Alain LavigneDate: 2002-07-16 17:24:38
Subject: Need help on a troublesome query plan

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