Variable in string PostgreSQL

Question

I have code written in postgreSQL database:

SELECT ST_Distance(gg1, gg2) As spheroid_dist, ST_Distance(gg1, gg2, false) As sphere_dist
FROM (SELECT
   'SRID=4326;POINT(-72.1235 42.3521)'::geography as gg1,
   'SRID=4326;LINESTRING(-72.1260 42.45, -72.123 42.1546)'::geography as gg2
   ) As foo  ;

and instead of 'POINT(-72.1235 42.3521)' and LINESTRING(-72.1260 42.45, -72.123 42.1546)' I want to add a point which is selected from table:

SELECT ST_asText(geog) FROM punkty WHERE gid = 1

How to add a selected variable into string in psql database?

Jim Jones · Accepted Answer · 2020-06-08 07:31:28Z

1

Welcome to SO.

I might be oversimplifying your question, but simply adding both tables in the where clause or a join (if possible) would do it.

Example:

SELECT 
  ST_Distance(t1.geog, t2.geog) As spheroid_dist, 
  ST_Distance(t1,geog, t2.geog, false) As sphere_dist
FROM 
  punkty2 t1, punkty2 t2 
WHERE t1.gid = 1 AND t2.gid = 2

answered Jun 8, 2020 at 7:31

Jim Jones

19.9k3 gold badges44 silver badges51 bronze badges

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

Collectives™ on Stack Overflow

Variable in string PostgreSQL

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