| From: | "Chad Thompson" <chad(at)weblinkservices(dot)com> |
|---|---|
| To: | "pgsql-novice" <pgsql-novice(at)postgresql(dot)org>, "pgsql-sql" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Seeding |
| Date: | 2002-07-15 18:45:58 |
| Message-ID: | 045701c22c2f$dd8d3860$32021aac@chad |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
Is there any way to automaticly "seed" a number into a list. For example
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'
can this be done through sql? or what would be the best approach.
TIA
Chad
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2002-07-15 22:54:36 | Re: [SQL] Seeding |
| Previous Message | Ron Johnson | 2002-07-15 17:35:50 | Re: removing specific duplicates |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-07-15 19:00:07 | Indexing UNIONs |
| Previous Message | Bruce Momjian | 2002-07-15 17:51:02 | Re: [SQL] |