postgre中 delete语句中使用 limit 报错。

[sun0322]

看网上说mysql都可以，难道说postgre不能这么用吗？

delete from TBL where column1='11' AND id like '1%' limit 10000

syntax error nera limit at character...

[wwwwb]

ps9.1
with aa as
(select * from tbl where column1='11' AND id like '1%' limit 10000)
delete from aa;

[sun0322]

[Quote=引用 1 楼 的回复:]

ps9.1
with aa as
(select * from tbl where column1='11' AND id like '1%' limit 10000)
delete from aa;
[/Quote]
psql -version
psql(8.4.1)
syntax error nera "delete" at character...

[wwwwb]

升级吧，看看8.4是否支持WITH 这种语法

[sun0322]

[Quote=引用 3 楼 的回复:]

升级吧，看看8.4是否支持WITH 这种语法
[/Quote]

不可能升级...

[sun0322]

[Quote=引用 3 楼 的回复:]

升级吧，看看8.4是否支持WITH 这种语法
[/Quote]

除了升级还有别的办法吗？

[wwwwb]

试试，建立1个VIEW
select * from tbl where column1='11' AND id like '1%' limit 10000
再DELETE FROM VIEW

[sun0322]

[Quote=引用 6 楼 的回复:]

试试，建立1个VIEW
select * from tbl where column1='11' AND id like '1%' limit 10000
再DELETE FROM VIEW
[/Quote]
除了这个，还有没有别的方法。

如能解决，再加40分~

[iihero]

delete from tbl where pk in (select pk from tbl where column1='11' AND id like '1%' limit 10000)
pk是主键，看看这样行不行。

[wwwwb]

假设ID为唯一标识的字段
delete from TBL where id in(select id from tbl where column1='11' AND id like '1%' limit 10000)

[幸运的米粥]

你好 在下是Postgres的内核研发 关于这块内容，本人已经在内核上实现了，过几天会同步到本人博客上 有兴趣的小伙伴可以搜索：孤傲小二~阿沐 进行查看