On 2/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
On 2/19/07, Jim Crafton <[EMAIL PROTECTED]> wrote:
> If I have a simple table without an index column, and have multiple
> rows with the same data, is it possible to *only* delete one row? In
> other words, is there anything like the LIMIT syntax that's found in
> the SELECT command for DELETEs?
>
you could select all distinct records in a temp table, drop the
original table, and recreate the table
CREATE TEMP TABLE tmp AS
SELECT DISTINCT *
ack! never mind. This does what I thought you asked, not what you
actually asked. Time to go to bed.
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
