Andrew Kane

Results 377 comments of 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...