-- GeoServer SQL views without time support
INSERT INTO sys_admin.published_services (
    schema, name, srid, key_column, view_def
) VALUES
    ('waterway', 'sounding_results_marking_points_geoserver', 4326, NULL, $$
        SELECT bottleneck_id,
            to_char(date_info, 'YYYY-MM-DD') AS date_info,
            height,
            points,
            surtyp,
            zpg_exception
        FROM waterway.sounding_results_marking_points mp
            JOIN waterway.sounding_results sr ON sr.id = mp.sounding_result_id
    $$);