[postgis-users] making Hexagoan from coordinate x, y and using distance

[Sandro Santilli]

On Fri, Dec 06, 2013 at 11:34:40AM +0530, anurag singh 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 .*

Try this: https://github.com/CartoDB/cartodb/blob/v2.5.6/lib/sql/scripts-available/CDB_Hexagon.sql

--strk;