Posts

Showing posts from May, 2023

Enable Dark Mode For Web Content In Microsoft Edge

Image
From  Enable Dark Mode For Web Content In Microsoft Edge Enable Dark Mode for Web Content in Microsoft Edge | Windows 11 December 13, 2022   by  Alok Kumar Mishra Let’s learn how to  Enable Dark Mode for Web Content in Microsoft Edge  in Windows 11. Microsoft Edge is enabled with many latest settings in it. Dark Mode is one of the coolest features nowadays. All operating systems and applications adopt that. The  dark  mode does not suit all the applications and website content. So Microsoft Edge has some settings that help users  enable  or  disable  it. We will go through this in detail in this post. The user can manually change the settings to enable or disable the Microsoft edge  dark mode  using the theme settings and from  appearance . Users also forcefully enable the dark mode applied to all the web content. This post describes the methods to enable  web content  in dark mode using Microsoft edge settings. You can read the post completely to know the details about the  MS Edge se

HOW TO COMPARE MULTIPLE COLUMNS AND ROWS OF A TABLE-POSTGRESQL

[From https://www.appsloveworld.com/postgresql/100/156/how-to-compare-multiple-columns-and-rows-of-a-table ]   The user input can be supplied using a VALUES clause in a common table expression and that can then be used in a left join with the actual table. with user_input (marker, value1, value2) as ( values ('A', 10, 11), ('B', 12, 13), ('C', 14, 14) ) select d.id, count(*) filter (where (d.marker, d.value1, d.value2) is not distinct from (u.marker, u.value1, u.value2)), 100 * count(*) filter (where (d.marker, d.value1, d.value2) is not distinct from (u.marker, u.value1, u.value2)) / cast(count(*) as numeric) as pct from data d left join user_input u on (d.marker, d.value1, d.value2) = (u.marker, u.value1, u.value2) group by d.id order by d.id; Returns: id | count | pct ---+-------+------ 1 | 2 | 66.67 2 | 2 | 66.67 3 | 1 | 50.00 Online example:  https://rextester.com/OBOOD9042 Edit If the order of the values i