Skip site navigation (1) Skip section navigation (2)

Re: [SQL] Seeding

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Chad Thompson <chad(at)weblinkservices(dot)com>
Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org>,pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] Seeding
Date: 2002-07-15 22:54:36
Message-ID: Pine.LNX.4.44.0207160049330.2259-100000@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-sql
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(at)gmx(dot)net


In response to

  • Seeding at 2002-07-15 18:45:58 from Chad Thompson

Responses

  • Re: Seeding at 2002-07-16 17:31:12 from Chad Thompson

pgsql-novice by date

Next:From: Jim MorcombeDate: 2002-07-16 03:51:41
Subject: Can't link to libpq
Previous:From: Chad ThompsonDate: 2002-07-15 18:45:58
Subject: Seeding

pgsql-sql by date

Next:From: Jie LiangDate: 2002-07-15 23:22:54
Subject: Re: pg_restore cannot restore index
Previous:From: Bruce MomjianDate: 2002-07-15 22:23:46
Subject: Re: pg_restore cannot restore index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group