How to delete multiple records

Поиск
Список
Период
Сортировка
От Javanesevn
Тема How to delete multiple records
Дата
Msg-id 4508F1A7.3040907@sangtao.net
обсуждение исходный текст
Ответы Re: How to delete multiple records
Re: How to delete multiple records
Список pgsql-sql
Dear all,

I execute this query on below:
     delete from PRODUCT     where exists (          select                product_id, item_id          from PRODUCT
     where               research_date < '2006-01-01'    )
 
this query deleted all records data in PRODUCT table. The subquery 
return only some records.
Tell me about other idea? and What's wrong from this query.

Best regards,

-Javanesevn


В списке pgsql-sql по дате отправления:

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: Aggregates with internal state type?
Следующее
От: Markus Schaber
Дата:
Сообщение: Re: How to delete multiple records