From: Chad Thompson <chad@weblinkservices.com>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-novice <pgsql-novice@postgresql.org>
Subject: Re: Seeding
Date: Tue, 16 Jul 2002 11:31:12 -0600
Message-ID: <04b301c22cee$95401a40$32021aac@chad> (raw)
References: <Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain>
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
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chad@weblinkservices.com, peter_e@gmx.net, pgsql-novice@postgresql.org
Subject: Re: Seeding
In-Reply-To: <04b301c22cee$95401a40$32021aac@chad>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox