Martin Hart <martin@zsdfherg.com> writes:
> db=# select '(1,2)'::point::text;
> ERROR: cannot cast type point to text
> the only way i have been able to achieve it is to write a plpgsql function:
> while this appears to work fine - I am wondering if I am missing something
> fundamental - specifically whether or not there is an inbuilt way to do it
> (which I guess there must be for the plpgsql function to work)?
plpgsql is effectively doing
regression=# select textin(point_out('(1,2)'::point));
textin
--------
(1,2)
(1 row)
There is not a one-step cast function for this. (Not for any
fundamental reason, just a lack of round tuits.)
regards, tom lane