On Fri, Jun 16, 2017 at 4:33 PM, Dan Book <[email protected]> wrote: > The recently added bind type support should help, see the last example here: > https://metacpan.org/pod/Mojo::Pg::Database#query >
Thanks Dan! You are right. That seems to work for insert, supported by query() But for retrieval queries (using query() or select()) I think the limitation is in $results->hash only expands json or jsonb in the _expand subroutine in Mojo::Pg::Results Looking at the code in _expand (some of it is a bit mind bending) maybe there is a way to do it by querying a single field in the select statement (single field select with type=PG_BYTEA) but I tried several ways and none worked. I believe adding a new case to the json/jsonb case in _results for the bytea type and support "raw" bytes could solve the issue but I am time constrained and it's cheaper for me to change the database model for now than trying to hack away at this. It would be nice though if this is supported in the future or if someone volunteers to submit a patch in this regard. Best, Alejandro Imass -- You received this message because you are subscribed to the Google Groups "Mojolicious" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/mojolicious. For more options, visit https://groups.google.com/d/optout.
