order_by() how to use NULLS LAST in active records |
I am using Potgresql with Codeigniter3 and i have query that have null values in some columns that i need to use for order_by() on those columns.
When i tried to run this query in pgAdmin it works and moving null values on last place, which is fine Code: SELECT a.*, b.*, c.* result Code: ----------------------------------- here is query from model which doesn't put nulls on last place Code: $this->db->select('a.*, b.*, c.*'); result Code: ----------------------------------- how i can implement NULLS LAST in active record in codeigniter in order_by() function |
Messages In This Thread |
order_by() how to use NULLS LAST in active records - by brianjamestorr - 11-05-2020, 01:19 AM
RE: order_by() how to use NULLS LAST in active records - by vincent78 - 11-05-2020, 03:54 AM
RE: order_by() how to use NULLS LAST in active records - by brianjamestorr - 11-05-2020, 04:04 AM
RE: order_by() how to use NULLS LAST in active records - by InsiteFX - 11-05-2020, 12:32 PM
RE: order_by() how to use NULLS LAST in active records - by brianjamestorr - 11-05-2020, 01:12 PM
RE: order_by() how to use NULLS LAST in active records - by vincent78 - 11-06-2020, 03:18 AM
RE: order_by() how to use NULLS LAST in active records - by InsiteFX - 11-06-2020, 06:01 AM
RE: order_by() how to use NULLS LAST in active records - by Reynaldi Ruspandi - 05-29-2021, 07:20 PM
|