On 9/16/24 20:34, Dan Langille wrote:
On Mon, Sep 16, 2024, at 5:46 PM, Phil Stracchino wrote:
On 9/16/24 15:17, Dan Langille wrote:

delete from version order by version limit 1;

bacula=*# delete from version order by version limit 1;
ERROR:  syntax error at or near "order"
LINE 1: delete from version order by version limit 1;

Doh, my bad. Forgot you can't use ORDER BY in a DELETE FROM. (Which means you have to use shenanigans when you want to do that.)


--
  Phil Stracchino
  Fenian House Publishing
  ph...@caerllewys.net
  p...@co.ordinate.org
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958



_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to