Hello,

I'm trying to get the following query,

$db->query("SELECT some_column FROM some_table WHERE jsonb_column -> 'foo' 
\@> ?::jsonb", { json => $bar }  );

to work using $db->select('some_table', ['some_column'], { ... } ) because 
of the quoting in the json on the left.  here is my failed attempt:

    $db->select('some_table', ['some_column'],
        {
          q{jsonb_column -> 'foo'} => 
          {
            '<@ ?::jsonb', {-json => $bar }
          }
        }
    );

the query above works, which is very pleasing.  Is there a way to get it 
working using select? 

Demian

-- 
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.

Reply via email to