From: Shawn <postgres@xmtservices.net>
To: pgsql-sql@postgresql.org
Subject: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
Date: Wed, 26 Mar 2008 22:45:53 +0000
User-Agent: KMail/1.9.9
References: 
 <032620081632.25756.47EA7AA200070FAB0000649C22007374789D0A900E04050E@comcast.net>
	<29426.1206551668@sss.pgh.pa.us>
In-Reply-To: <29426.1206551668@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Message-Id: <200803262245.53968.postgres@xmtservices.net>

On Wednesday 26 March 2008 17:14:28 Tom Lane wrote:
> Or even easier:
>
> regression=3D# select 134987 * interval '1 msec';
> =A0 =A0?column? =A0
> --------------
> =A000:02:14.987
> (1 row)
>
>
> =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0r=
egards, tom lane

Tom and Adrian,

i am trying to incorporate the solution you gave into a function, trying to=
=20
save some typing.  Its keeps throwing a syntax error:

edacs=3D# create or replace function dur_interval_msec(char) returns interv=
al
as 'select ($1 * interval '1 msec');'
language sql
immutable
returns null on null input;
ERROR:  syntax error at or near "1"
LINE 2: as 'select ($1 * interval '1 msec');'
                                   ^
obviously it doesn't like the extra single quotes around the 1 msec.  Any=20
suggestions for a work around?

Shawn