Calling returning value from select statement

Question

I need to insert a polygon into a postgresql table "polygontable" and then return its (the_geom) value for further querying. I want to be grabbing the most recently inserted instance in "polygontable". How do I call the returned "polygongeom" in a SELECT statement?

INSERT INTO polygontable (the_geom) 
VALUES (ST_SetSRID((ST_MakeValid(ST_GeomFromGeoJSON('"+JSON.stringify(payload)+"'))),4326)) returning the_geom as polygon_geom;  

SELECT st_intersects(polygon_geom, other_table.the_geom) 
from polygon_geom, other_table;

user330315 · Accepted Answer · 2012-06-14 22:30:39Z

2

If you are on 9.1 you can do something like this:

with inserted as 
(
  insert into ... 
  returning the_geom as new_geom
)
SELECT st_intersects(inserted.new_geom, other_table.the_geom) 
from inserted, other_table;

answered Jun 14, 2012 at 22:30

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Calling returning value from select statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related