Home > mailing lists

Thread: Seeding

Seeding

From

"Chad Thompson"

Date:

15 July 2002, 17:46:02

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

Re: Seeding

From

Peter Eisentraut

Date:

15 July 2002, 21:52:02

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