Andrew Kane
Andrew Kane
@stefanfritsch thanks for the suggestion. This use case doesn't seem very common, so I think it's best accomplished outside of dbx.
Hey @budfox123, thanks for the suggestions. I've considered adding a more ORM-type function for constructing queries (instead of writing SQL manually), but want to keep things simple for now. You...
Hey @psimm, both run `dbExecute` behinds the scenes (unless `returning` is passed to upsert), so it could probably sum them. Can you explain the use case a bit more?
If you're on Postgres and use the version from GitHub, you can do: ```R dbxUpsert(db, table, records, where_cols=c("id"), returning=DBI::SQL("id, (xmax = 0) AS inserted")) ``` I'm not sure if it's...
Hey @fabienpiette, thanks for the PR, including tests 💯 As I was going reviewing/compiling feedback for this, I think I found a slightly different way that doesn't require a custom...
Great, glad it's working, and fwiw, your PR helped out a lot - was much easier to make some tweaks than start from scratch. Going to leave this feature in...
Hey Josh, honored to have your input on a project. Huge thanks for your contributions to Postgres! I really like the simplicity of this idea. For the case when stats...
Hey @gmverdon, just added support for this on master.
Hi @isoos, thanks for adding! A few initial thoughts: 1. It'd be nice to be able to register types by name (in addition to OID). Otherwise, for types with a...
Thanks @isoos. 1. I think it's better for the library to handle the complexity rather than each developer. Thinking about it more, it'd be nice to be able to register...