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.)
>
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
called often it seems a bit of a waste
of resources looking it up each time the procedure is run.
Is this the sort of thing that internal variables would handle (by that I mean
using "set" and "show")?
TIA
Martin
--
Martin Hart
Arnclan Limited
53 Union Stree
