PostgreSQL - deleting a range.
 

hey,


i'm trying to delete a range of rows in PostgreSQL.

i've tried using various commands but not of them work. Is there a way to delete a range or do i have to make a script that generates every delete statement invidiuvally....




thanks,
djgerbavor3

If you want to delete a range it means you have a criteria. You can use WHERE in DELETE exactly as in SELECT. So, for example
DELETE FROM table WHERE field > value1 AND field < value2;

In addition to mara's suggestion you could have a look at
where EXP1 between EXP2 and EXP3
or
where EXP1 in (EXP2, EXP3, .... )



Cheers,
Tink