From: Roberto Mello <rmello@cc.usu.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: daq <daq@ugyvitelszolgaltato.hu>
Cc: Luke Pascoe <luke.p@kmg.co.nz>
Cc: pgsql-sql@postgresql.org
Subject: Re: CAST from VARCHAR to INT
Date: Fri, 24 Jan 2003 12:03:56 -0700
Message-ID: <20030124190356.GC20178@cc.usu.edu> (raw)
In-Reply-To: <13400.1043422949@sss.pgh.pa.us>
References: <01df01c2c354$2bac5a60$3200000a@K2>
<21242862808.20030124112835@ugyvitelszolgaltato.hu>
<13400.1043422949@sss.pgh.pa.us>
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, tgl@sss.pgh.pa.us, daq@ugyvitelszolgaltato.hu, luke.p@kmg.co.nz
Subject: Re: CAST from VARCHAR to INT
In-Reply-To: <20030124190356.GC20178@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox