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