On Tuesday 09 December 2003 14:56, Tom Lane wrote:
> 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.)
>
Martin Hart <[EMAIL PROTECTED]> 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 - specifica
Hi all,
PG 7.4 beta4 (not had a chance to upgrade yet :-(
how do i cast something of type point to text?
db=# select '(1,2)'::point::text;
ERROR: cannot cast type point to text
db=# select text('(1,2)'::point);
ERROR: function text(point) does not exist
HINT: No function matches the given na
