PostgreSQL--数据对比柱状图

一.业务场景

pgsql查询多个id的数据，并分组对比，并求最大最小值。

二.sql参考

SELECT
	es.name,
	MAX ( ws.average_wind_speed ) AS wind_speed,
	MAX ( ws.average_wind_direct ) AS wind_direct 
FROM
	enavmark_station es
	LEFT JOIN enavmark_windspeed ws ON ws.aton_id = es.aton_id 
	AND ws.acquisition_timestamp = '2021-05-07 11:04:08'
WHERE
	CAST ( es.aton_id AS VARCHAR ) = ANY ( regexp_split_to_array('994140201,994140202,994140203', E',' ) ) 
GROUP BY
	es.name

涉及pgsql语法：ANY   CAST  regexp_split_to_array