From chad@weblinkservices.com Mon Jul  15 18:45:59 2002
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" <chad@weblinkservices.com>
To: "pgsql-novice" <pgsql-novice@postgresql.org>,
	"pgsql-sql" <pgsql-sql@postgresql.org>
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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2713.1100" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Is there any way to automaticly "seed" a n=
umber=20
into a list.&nbsp; For example</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>create table "temp"(</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>select distinct(full_phone)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>from lists</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>where client_id =3D8)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>This gives me 100,000 unique records</FONT=
></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>What i would like to do is, every 2500, in=
sert a=20
specific number like '5552552555'</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>can this be done through sql? or what woul=
d be the=20
best approach.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>TIA</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Chad</FONT></DIV></BODY></HTML>

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




From peter_e@gmx.net Mon Jul  15 22:52:00 2002
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by postgresql.org (Postfix) with SMTP id EE028475AF9
	for <pgsql-novice@postgresql.org>; Mon, 15 Jul 2002 18:52:00 -0400 (EDT)
Received: (qmail 26661 invoked by uid 0); 15 Jul 2002 22:52:02 -0000
Received: from pd902f0d7.dip0.t-ipconnect.de (217.2.240.215)
	by mail.gmx.net (mp013-rz3) with SMTP; 15 Jul 2002 22:52:02 -0000
Date: Tue, 16 Jul 2002 00:54:36 +0200 (CEST)
From: Peter Eisentraut <peter_e@gmx.net>
X-X-Sender: peter@localhost.localdomain
To: Chad Thompson <chad@weblinkservices.com>
Cc: pgsql-novice <pgsql-novice@postgresql.org>,
	pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: [SQL] Seeding
In-Reply-To: <045701c22c2f$dd8d3860$32021aac@chad>
Message-ID: <Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200207/119
X-Sequence-Number: 4288

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




From chad@weblinkservices.com Tue Jul  16 17:31:02 2002
Received: from utahisp.com (www.cyber-wire.com [209.119.76.3])
	by postgresql.org (Postfix) with ESMTP id D0710474E42
	for <pgsql-novice@postgresql.org>; Tue, 16 Jul 2002 13:31:02 -0400 (EDT)
Received: from chad [63.230.8.76] by utahisp.com
	(SMTPD32-5.05) id A74122570078; Tue, 16 Jul 2002 11:26:25 -0600
Message-ID: <04b301c22cee$95401a40$32021aac@chad>
From: "Chad Thompson" <chad@weblinkservices.com>
To: "Peter Eisentraut" <peter_e@gmx.net>
Cc: "pgsql-novice" <pgsql-novice@postgresql.org>
References: <Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain>
Subject: Re: Seeding
Date: Tue, 16 Jul 2002 11:31:12 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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/121
X-Sequence-Number: 4290

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
>
>




From ron.l.johnson@cox.net Tue Jul  16 18:38:23 2002
Received: from lakemtao04.cox.net (lakemtao04.cox.net [68.1.17.241])
	by postgresql.org (Postfix) with ESMTP id 94263475CAF
	for <pgsql-novice@postgresql.org>; Tue, 16 Jul 2002 14:38:23 -0400 (EDT)
Received: from localhost.localdomain ([68.11.66.83]) by lakemtao04.cox.net
	(InterMail vM.5.01.04.05 201-253-122-122-105-20011231) with ESMTP
	id <20020716183825.OVGQ4949.lakemtao04.cox.net@localhost.localdomain>
	for <pgsql-novice@postgresql.org>; Tue, 16 Jul 2002 14:38:25 -0400
Subject: Re: Seeding
From: Ron Johnson <ron.l.johnson@cox.net>
To: PgSQL Novice ML <pgsql-novice@postgresql.org>
In-Reply-To: <04b301c22cee$95401a40$32021aac@chad>
References: <Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain>
	<04b301c22cee$95401a40$32021aac@chad>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.7 
Date: 16 Jul 2002 13:38:22 -0500
Message-Id: <1026844703.24332.82.camel@rebel>
Mime-Version: 1.0
X-Archive-Number: 200207/122
X-Sequence-Number: 4291

On Tue, 2002-07-16 at 12:31, Chad Thompson wrote:
> So if there is an order by in that statement and i want to insert every 2500
> records is that specific?

But you'll still have trouble, since the next time you say
ORDER BY FULL_PHONE, all of the records with FULL_PHONE='5552552555'
will all be grouped together.

What is the reason for wanting these '5552552555' records?
Maybe there is another way to skin this cat...
 
> 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.

-- 
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "The greatest dangers to liberty lurk in insidious encroachment |
|  by men of zeal, well-meaning, but without understanding."      |
|   Justice Louis Brandeis, dissenting, Olmstead v US (1928)      |
+-----------------------------------------------------------------+




From chad@weblinkservices.com Tue Jul  16 19:38:46 2002
Received: from utahisp.com (www.cyber-wire.com [209.119.76.3])
	by postgresql.org (Postfix) with ESMTP id D65F4475A4A
	for <pgsql-novice@postgresql.org>; Tue, 16 Jul 2002 15:38:46 -0400 (EDT)
Received: from chad [63.230.8.76] by utahisp.com
	(SMTPD32-5.05) id A533586A03DE; Tue, 16 Jul 2002 13:34:11 -0600
Message-ID: <050d01c22d00$6f2a5390$32021aac@chad>
From: "Chad Thompson" <chad@weblinkservices.com>
To: "Ron Johnson" <ron.l.johnson@cox.net>,
	"pgsql-novice" <pgsql-novice@postgresql.org>
References: <Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain>
	<04b301c22cee$95401a40$32021aac@chad>
	<1026844703.24332.82.camel@rebel>
Subject: Re: Seeding
Date: Tue, 16 Jul 2002 13:38:59 -0600
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
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/124
X-Sequence-Number: 4293

I feed this list into a 3rd party dialer.  My objective is to try to have my
number or the clients number called during the running of the project.  I
need the list to be generated from the database so the results of the
project will be submitted to the database.  (if i generate a text file to
feed to the dialer the results only show up in a text file.)

Thanks
Chad
----- Original Message -----
From: "Ron Johnson" <ron.l.johnson@cox.net>
To: "PgSQL Novice ML" <pgsql-novice@postgresql.org>
Sent: Tuesday, July 16, 2002 12:38 PM
Subject: Re: [NOVICE] Seeding


> On Tue, 2002-07-16 at 12:31, Chad Thompson wrote:
> > So if there is an order by in that statement and i want to insert every
2500
> > records is that specific?
>
> But you'll still have trouble, since the next time you say
> ORDER BY FULL_PHONE, all of the records with FULL_PHONE='5552552555'
> will all be grouped together.
>
> What is the reason for wanting these '5552552555' records?
> Maybe there is another way to skin this cat...
>
> > 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.
>
> --
> +-----------------------------------------------------------------+
> | Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
> | Jefferson, LA  USA                                              |
> |                                                                 |
> | "The greatest dangers to liberty lurk in insidious encroachment |
> |  by men of zeal, well-meaning, but without understanding."      |
> |   Justice Louis Brandeis, dissenting, Olmstead v US (1928)      |
> +-----------------------------------------------------------------+
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>




From peter_e@gmx.net Wed Jul  17 22:30:20 2002
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by postgresql.org (Postfix) with SMTP id 13B0A475DDC
	for <pgsql-novice@postgresql.org>; Wed, 17 Jul 2002 18:30:20 -0400 (EDT)
Received: (qmail 30260 invoked by uid 0); 17 Jul 2002 22:30:21 -0000
Received: from pd902f0de.dip0.t-ipconnect.de (217.2.240.222)
	by mail.gmx.net (mp015-rz3) with SMTP; 17 Jul 2002 22:30:21 -0000
Date: Thu, 18 Jul 2002 00:33:07 +0200 (CEST)
From: Peter Eisentraut <peter_e@gmx.net>
X-X-Sender: peter@localhost.localdomain
To: Chad Thompson <chad@weblinkservices.com>
Cc: pgsql-novice <pgsql-novice@postgresql.org>
Subject: Re: Seeding
In-Reply-To: <04b301c22cee$95401a40$32021aac@chad>
Message-ID: <Pine.LNX.4.44.0207172141500.9047-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200207/150
X-Sequence-Number: 4319

Chad Thompson writes:

> 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)

That will make the table temporarily ordered, but that will only last
until the next update.

Maybe you want to number your records, and then you can insert the records
you want at the numbers you want (2500, 5000, ...).

-- 
Peter Eisentraut   peter_e@gmx.net