14 lines
521 B
PL/PgSQL
14 lines
521 B
PL/PgSQL
CREATE
|
|
OR REPLACE FUNCTION get_latest_versions (btcpayVersion INT[], includePreRelease BOOLEAN)
|
|
RETURNS TABLE(plugin_slug TEXT, ver INT[], build_id BIGINT)
|
|
AS $$
|
|
WITH latest_versions AS
|
|
(
|
|
SELECT plugin_slug, MAX(ver) ver FROM versions
|
|
WHERE (btcpayVersion IS NULL OR btcpay_min_ver <= btcpayVersion) AND (includePreRelease OR pre_release IS FALSE)
|
|
GROUP BY plugin_slug
|
|
)
|
|
SELECT v.plugin_slug, v.ver, v.build_id
|
|
FROM latest_versions lv
|
|
JOIN versions v USING (plugin_slug, ver) $$ LANGUAGE SQL STABLE;
|