Welcome Guest, Not a member yet? Register   Sign In
Query for json data type
#1

I'm new to CI4 sql builder, I'm trying to query the postgresql json data type, for example:

$db->where("dataUser ->> 'level' ",'true');
or $db->query("select * from login ul where dataUser ->> 'level' = 'true'");

when i run getCompiledSelect,
SELECT * FROM "login" WHERE dataUser ->> 'level' > :dataUser -> > 'level':
and
SELECT * FROM "login"
what can i do?
Reply


Messages In This Thread
Query for json data type - by candra - 06-13-2021, 01:51 AM
RE: Query for json data type - by iRedds - 06-13-2021, 09:56 AM
RE: Query for json data type - by candra - 06-14-2021, 06:09 AM



Theme © iAndrew 2016 - Forum software by © MyBB