Re: CAST from VARCHAR to INT

daq <daq(at)ugyvitelszolgaltato(dot)hu> writes:
> Make your life easier! :) You must write a function like
> this:

> create function "int4"(character varying) returns int4 as '
> DECLARE
> input alias for $1;
> BEGIN
> return (input::text::int4);
> END;
> ' language 'plpgsql';

> When you try the cast varchar_field::integer or varchar_field::int4 Postgres call
> the function named int4 and takes varchar type parameter.

Note that as of 7.3 you need to issue a CREATE CAST command; the name of
the function is not what drives this anymore. (Though following the old
naming convention that function name == return type still seems like a
good idea.)

regards, tom lane