Hi Anurag, Almost there! Quadsegs needs to be 2 (i.e. 2 * quad = oct):
SELECT ST_Buffer(ST_MakePoint(0, 0), 1000, 2); And if you are looking for a octagon that looks like a stop sign, then rotate it by 22.5 degrees, or pi/8 radians. It's a bit more complicated, since it needs a point of origin to rotate around: SELECT ST_Rotate(ST_Buffer(pt, 1000, 2), pi()/8, pt) FROM (SELECT ST_MakePoint(0, 0) AS pt) AS f; -Mike On 6 December 2013 19:04, anurag singh <[email protected]> wrote: > Hi everyone!!!!! > > This is my first question on this site. I am developing a small application > where there is a requirement for generating a buffer in form of regular > hexagon. > I have already created the circle using ST_Buffer(ST_MakePoint("x1"," y1"), > 1000, 4 ) but not getting that how i can create a regular hexagon. I am > stuck on this point > please help me . > > > -- > Thank's & Regard's > Anurag Singh > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
