Chad Thompson writes:
> So if there is an order by in that statement and i want to insert every 2500
> records is that specific?
> 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(at)gmx(dot)net
In response to
pgsql-novice by date
|Next:||From: Jim Morcombe||Date: 2002-07-18 02:42:06|
|Subject: Re: Problems linking to libpq|
|Previous:||From: Søren Neigaard||Date: 2002-07-17 20:43:42|
|Subject: How do I only allow one group access to my database|
pgsql-sql by date
|Next:||From: Josh Berkus||Date: 2002-07-18 00:19:22|
|Subject: Re: Indexing UNIONs|
|Previous:||From: Ligia Pimentel||Date: 2002-07-17 22:27:33|
|Subject: Re: How to find out if an index is unique?|