pixie icon indicating copy to clipboard operation
pixie copied to clipboard

Postgres: Update has syntax error

Open James-A1 opened this issue 7 years ago • 1 comments

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.

James-A1 avatar May 02 '18 11:05 James-A1

Postgres doesn't have LIMIT on update query (https://www.postgresql.org/message-id/3D6A7692.2F43B18%40Yahoo.com)

catchem99 avatar Jan 01 '19 02:01 catchem99