[PSQL - Select Next Event From Today]Use CTE to supplement time zone from another table #psql

psql-select-next-event-from-today.sql

WITH tz AS (
  SELECT gc.value AS tzv FROM public.gv_config gc WHERE gc.name =  'arena.timezone' LIMIT 1
)
SELECT 
        id
        , (NOW() AT TIME ZONE tz.tzv) now_arena
        , (NOW() AT TIME ZONE tz.tzv)::date now_arena_date
FROM 
        public.event_details ed
        , tz tz
WHERE 
        ticketing_ids @> (ARRAY['EV23LAV1'])::text[]
        AND (id >= (NOW() AT TIME ZONE tz.tzv)::date)
ORDER BY
        id, venue
LIMIT 1;