| 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> |
| Subject: | Re: [SQL] Seeding |
| Date: | 2002-07-15 22:54:36 |
| Message-ID: | Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Morcombe | 2002-07-16 03:51:41 | Can't link to libpq |
| Previous Message | Chad Thompson | 2002-07-15 18:45:58 | Seeding |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jie Liang | 2002-07-15 23:22:54 | Re: pg_restore cannot restore index |
| Previous Message | Bruce Momjian | 2002-07-15 22:23:46 | Re: pg_restore cannot restore index |