Received: from utahisp.com (www.cyber-wire.com [209.119.76.3]) by postgresql.org (Postfix) with ESMTP id A585B47586D; Mon, 15 Jul 2002 14:45:59 -0400 (EDT) Received: from chad [63.230.8.76] by utahisp.com (SMTPD32-5.05) id A7546B860234; Mon, 15 Jul 2002 12:41:24 -0600 Message-ID: <045701c22c2f$dd8d3860$32021aac@chad> From: "Chad Thompson" To: "pgsql-novice" , "pgsql-sql" Subject: Seeding Date: Mon, 15 Jul 2002 12:45:58 -0600 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0454_01C22BFD.91A40140" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200207/116 X-Sequence-Number: 4285 This is a multi-part message in MIME format. ------=_NextPart_000_0454_01C22BFD.91A40140 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 =3D8) This gives me 100,000 unique records What i would like to do is, every 2500, insert a specific number like '5552= 552555' can this be done through sql? or what would be the best approach. TIA Chad ------=_NextPart_000_0454_01C22BFD.91A40140 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Is there any way to automaticly "seed" a n= umber=20 into a list. For example

create table "temp"(

select distinct(full_phone)

from lists

where client_id =3D8)

This gives me 100,000 unique records

What i would like to do is, every 2500, in= sert a=20 specific number like '5552552555'

can this be done through sql? or what woul= d be the=20 best approach.

TIA

Chad

------=_NextPart_000_0454_01C22BFD.91A40140--