Re: [SQL] Seeding - Mailing list pgsql-novice

From Peter Eisentraut
Subject Re: [SQL] Seeding
Date
Msg-id Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain
Whole thread Raw
In response to Seeding  ("Chad Thompson" <chad@weblinkservices.com>)
List pgsql-novice
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 by date:

Previous
From: "Jim Morcombe"
Date:
Subject: Problems linking to libpq
Next
From: "Jim Morcombe"
Date:
Subject: Can't link to libpq