:)
On 2/20/07, P Kishor <[EMAIL PROTECTED]> wrote:
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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
