Re: Seeding
От | Chad Thompson |
---|---|
Тема | Re: Seeding |
Дата | |
Msg-id | 050d01c22d00$6f2a5390$32021aac@chad обсуждение исходный текст |
Ответ на | Re: [SQL] Seeding (Peter Eisentraut <peter_e@gmx.net>) |
Список | pgsql-novice |
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 >
В списке pgsql-novice по дате отправления: