Column sort shows empty information first

Questions and answers regarding general SQL and backend databases

Column sort shows empty information first

Postby joe26 » Tue Nov 27, 2018 2:20 am

Hi guys!

Sorting a column header shows empty information first.

I use Query Builder to build composite tables. Clicking on the table header shows empty information first.

I'm aware of SHOW NULLS FIRST | LAST as per another forum post, and it may be related to locale or collate settings on the db side.

I've reset some records to be blank instead of null, but perhaps, Postgres sees that as null information as well.

What is the recommended way to collate the table information to the top of the table?

thanks!
--Joe.
joe26
 
Posts: 172
Joined: Wed Jun 19, 2013 10:30 pm

Return to SQL Databases

Who is online

Users browsing this forum: No registered users and 6 guests

cron