David Kaplan
David Kaplan
The less than ideal solution that I eventually used for this situation was to parse the string representation of the array in R. But this only works easily because I...
I tried getting this to work with `adbi`, but I must admit I can't figure out how to successfully connect to a database. First I tried opening a connection with:...
`immediate=TRUE` fixed the issue! ```r > con2 = dbConnect(adbi::adbi("adbcpostgresql"),uri="postgresql://localhost:5432") > x=dbGetQuery(con2,"WITH a(v) AS (VALUES(ARRAY['a','b']::varchar[]),(ARRAY['abc','def','fgh']::varchar[])) SELECT * FROM a",immediate=TRUE) > x$v [[1]] [1] "a" "b" [[2]] [1] "abc" "def" "fgh" ```...
Hi, I recently just had to find a generic solution for converting 1-D Postgresql arrays in a `pq_varchar` column into a list of character vectors. The solution that was found...
No, I don't think `VALUES()` returns JSON in this example. What `pq_varchar_array_to_char()` would see is as follows: ```r > con q = "WITH a(v) AS (VALUES(ARRAY['''a''','b']::varchar[]),(ARRAY['abc, def','the \"big\" one','fgh']::varchar[])) SELECT...
> It's this commit [afc6f48](https://github.com/mdbtools/mdbtools/commit/afc6f4888b90c36e2c2089bf0b5eedec1c85ed8b) > > It says "adds support" but there's no way to decline the support 🙃 I suppose recompile and change the postgres backend to passthrough_unchanged()...
I am getting this error and I am wondering if there has been any progress on fixing it since the last comments?
I have this same problem.
Note that I am aware that I can just average the raster itself over depth and then apply `st_extract`, but I still want to understand what `st_extract` is doing when...
The first referent to `jQuery` occurs in line 3711 as: ```html if (window.jQuery) { if (previous) { window.jQuery(previous).trigger("hidden"); } if (current) { window.jQuery(current).trigger("shown"); } } }; ``` I have confirmed...