returning column problem in update or insert sql about pgmoon HOT 4 CLOSED

Can you share the code you're using to do this? returning definitely works with pgmoon, I use it heavily in all of my projects.

from pgmoon.

Sorry to trouble you, I got the reason, there is a mistake in my codes.

from pgmoon.

There's another problem, when I delete a non exist record in database:
if my sql is: delete from t1 where id=0, then the pgmoon returns {"affected_rows":0}
if my sql is: delete from t1 where id=0 returning id, then the pgmoon returns {}
I expect pgmoon should returns affected_rows at any time.

from pgmoon.

I'm kinda undecided on the behavior but I think it's safer to leave it as is. returning converts the query into something that has a result set, so if you want to could the number of affected rows you will have to could the number of results.

from pgmoon.