postgresql error st_point

SanhitaChatterjee2 — Thu, 12 Sep 2019 17:08:54 GMT

I am doing a union of multiple tables to create a view. All table include shape and have the same geometry type. I am getting the following errors while creating the spatial view: ERROR: could not identify an equality operator for type st_point LINE 8: td.shape . What am I not defining in shape in either tables that is causing the error?

A sample of my query for the view is as follows:

SELECT
td.storenum,
td.address,
td.city,
td.state,
td.zip,
td.shape
FROM
competitor_td td

where td.catcode= '05'

union

select
vw.store_num as storenum,
vw.address,
vw.city,
vw.st_abbrv as state,
vw.zip_code as zip,
vw.shape
FROM
store_vw vw
WHERE vw.status <> 'Closed'

Re: postgresql error st_point

George_Thompson — Thu, 12 Sep 2019 18:45:05 GMT

I am not an expert, but you may have the incorrect syntax; ST_Union & PostgreSQL: Documentation: 11: 7.4. Combining Queries

Re: postgresql error st_point

SanhitaChatterjee2 — Thu, 12 Sep 2019 18:50:20 GMT

Thanks. Simple fix- changed to union all and it worked.

topic Re: postgresql error st_point in Geodatabase Questions

postgresql error st_point

Re: postgresql error st_point

Re: postgresql error st_point