ices-eg / wg_WGEEL

Joint EIFAAC/ICES/GFCM Working Group on Eels
http://ices.dk/community/groups/Pages/WGEEL.aspx
5 stars 12 forks source link

st_geom #263

Closed cedricbriandgithub closed 1 year ago

cedricbriandgithub commented 1 year ago

Error: Failed to fetch row: ERREUR: la fonction st_point(numeric, numeric, integer) n'existe pas LINE 1: SELECT coalesce(st_contains(geom,st_point(n... ^ HINT: Aucune fonction ne correspond au nom donné et aux types d'arguments. Vous devez ajouter des conversions explicites de type. QUERY: SELECT coalesce(st_contains(geom,st_point(new.fisa_x_4326, new.fisa_y_4326, 4326)), true) FROM
datawg.t_samplinginfo_sai JOIN REF.tr_emu_emu ON emu_nameshort=sai_emu_nameshort where new.fisa_sai_id = sai_id CONTEXT: fonction PL/pgSQL datawg.fish_in_emu(), ligne 9 à