Search Postgresql Archives

Delete from table conditionally

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

I am using Postgresql 9.5.

Below is the sample data taken from the mail table with only required columns:

id | question_id | answer_id | content
----+-------------+-----------+----------
2 |          25 |       270 | Arup
3 |          26 |       276 | Kajal
4 |          26 |       276 | Arup
5 |          27 |       280 | Kajal
6 |          25 |       270 | Arup
7 |          25 |       270 | Lalu
8 |          25 |       270 | Arup
9 |          26 |       274 |  Dilip
10 |          25 |       270 | doli
11 |          25 |       270 | Arup
(10 rows)


Say, I know the id 6 where content is "Arup". Now from this row, I want to delete all next rows where the content is "Arup". How should I achieve this?


Regards,
Arup Rakshit


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux