A continuación se muestran el esquema y los datos de mi tabla.
#Table Structure CREATE TABLE public.route ( name text NOT NULL, startpoint point NOT NULL, endpoint point NOT NULL, id integer NOT NULL DEFAULT nextval('route_id_seq'::regclass), CONSTRAINT route_pkey PRIMARY KEY (id) ) WITH ( OIDS=FALSE ); #Table Data INSERT INTO public.route (name, startpoint, endpoint, id) VALUES ('Atlantic', (-73.848838,40.688299), (-73.824869,40.694831), 1); INSERT INTO public.route (name, startpoint, endpoint, id) VALUES ('Guy Brewer', (-73.7991,40.708257), (-73.78543,40.688334), 2); desea verificar si el punto de inicio de la columna tiene un punto (-73.848838,40.688299) startpoint la tabla de route
SELECT * FROM route WHERE startpoint ~= POINT '(-73.848838,40.688299)';Puede acelerar esto con un índice GiST:
CREATE INDEX ON route USING gist (startpoint);