Date: Fri, 24 Jan 2003 12:03:56 -0700
From: Roberto Mello <rmello@cc.usu.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: daq <daq@ugyvitelszolgaltato.hu>, Luke Pascoe <luke.p@kmg.co.nz>,
	pgsql-sql@postgresql.org
Subject: Re: CAST from VARCHAR to INT
Message-ID: <20030124190356.GC20178@cc.usu.edu>
References: <01df01c2c354$2bac5a60$3200000a@K2>
	<21242862808.20030124112835@ugyvitelszolgaltato.hu>
	<13400.1043422949@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <13400.1043422949@sss.pgh.pa.us>
User-Agent: Mutt/1.4i

On Fri, Jan 24, 2003 at 10:42:29AM -0500, Tom Lane wrote:
> daq <daq@ugyvitelszolgaltato.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.)

Wow, I didn't even know of either of these features. Sounds useful.

-Roberto

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
Friends encourage friends to use Win(e)dows - under Linux!