1. What function can I use so that it would check if Location1 is inside Region1, and if yes return a value of 1 or 'True'? I am currently using Teradata 14.10.
New ST_GEOMETRY('Point(149.5 -34.5)') As Location1,
New ST_GEOMETRY('Polygon((150 -35, 150 -34, 149 -34, 149 -35))') As Region1
2. If I have a table of points and a table of regions (a name field and a polygon field), how would I map all points to their respective regions?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.