pixie
pixie copied to clipboard
Postgres: Update has syntax error
Hi, I'm using postgresql and I just tried to use the pixie's update method like so:
QB::table('persons')->where('id', $id)->update(['name' => 'Jack']);
It is giving me a syntax error by adding the LIMIT 1 to the end of the query.
Postgres doesn't have LIMIT on update query (https://www.postgresql.org/message-id/3D6A7692.2F43B18%40Yahoo.com)