I am trying to run a buffer around a polyline (geography). My first attempt below (based on this). http://postgis.net/docs/ST_Buffer.html

my attempt.

SELECT ST_Buffer(ST_Geomfromtext(i30.geog),10,'endcap=round join=round');

creates an error: missing FROM-clause entry for table "i30" ST_Geomfromtext(^herei30.geog)

I am trying to run a buffer around a polyline (geography). My first attempt below (based on ST_Buffer documentation:

SELECT ST_Buffer(ST_Geomfromtext(i30.geog),10,'endcap=round join=round');

gives an error:

missing FROM-clause entry for table "i30"
ST_Geomfromtext(**^here**i30.geog)      

I am trying to run a buffer around a polyline (geography). My first attempt below (based on this). http://postgis.net/docs/ST_Buffer.html

my attempt.

SELECT ST_Buffer(ST_Geomfromtext(i30.geog),10,'endcap=round join=round');

creates an error: missing FROM-clause entry for table "i30" ST_Geomfromtext(^herei30.geog)

Andy.

I am trying to run a buffer around a polyline (geography). My first attempt below (based on this). http://postgis.net/docs/ST_Buffer.html

my attempt.

SELECT ST_Buffer(ST_Geomfromtext(i30.geog),10,'endcap=round join=round');

creates an error: missing FROM-clause entry for table "i30" ST_Geomfromtext(^herei30.geog)