On Wednesday 26 March 2008 23:12:07 Rodrigo E. De León Plicet wrote:
> Use dollar quoting, e.g.:
>
> create or replace function dur_interval_msec(int) returns interval
> as
> $$
> select ($1 * interval '1 msec');
> $$
> language sql
> immutable
> returns null on null input;
Perfect! Great! Thank
On Wed, Mar 26, 2008 at 5:45 PM, Shawn <[EMAIL PROTECTED]> wrote:
> obviously it doesn't like the extra single quotes around the 1 msec. Any
> suggestions for a work around?
Use dollar quoting, e.g.:
create or replace function dur_interval_msec(int) returns interval
as
$$
select ($1 * interval
On Wednesday 26 March 2008 17:14:28 Tom Lane wrote:
> Or even easier:
>
> regression=# select 134987 * interval '1 msec';
> ?column?
> --
> 00:02:14.987
> (1 row)
>
>
> regards, tom lane
Tom and Adrian,
i am trying to incorporate the solution you gave int
-- Original message --
From: Tom Lane <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] (Adrian Klaver) writes:
> > Select 134987 * interval '1 msec';
> > ERROR: invalid input syntax for type interval: "1 msec"
>
> > SELECT version();
> >
[EMAIL PROTECTED] (Adrian Klaver) writes:
> Select 134987 * interval '1 msec';
> ERROR: invalid input syntax for type interval: "1 msec"
> SELECT version();
> version
>
-- Original message --
From: Tom Lane <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] (Adrian Klaver) writes:
> > select ('134987'::int/1000.00) * interval ' 1 second' ;
> > ?column?
> > --
> > 00:02:14.987
> > (1 row)
>
> Or even easier:
>
> regres
-- Original message --
From: Tom Lane <[EMAIL PROTECTED]>
> [EMAIL PROTECTED] (Adrian Klaver) writes:
> > select ('134987'::int/1000.00) * interval ' 1 second' ;
> > ?column?
> > --
> > 00:02:14.987
> > (1 row)
>
> Or even easier:
>
> regressi
[EMAIL PROTECTED] (Adrian Klaver) writes:
> select ('134987'::int/1000.00) * interval ' 1 second' ;
> ?column?
> --
> 00:02:14.987
> (1 row)
Or even easier:
regression=# select 134987 * interval '1 msec';
?column?
--
00:02:14.987
(1 row)
-- Forwarded Message: --
From: [EMAIL PROTECTED] (Adrian Klaver)
To: Shawn <[EMAIL PROTECTED]>
Subject: Re: [SQL] Part 1 of several - Converting a varchar to an interval
Date: Wed, 26 Mar 2008 16:16:58 +
>
>
>
>
> --
On Wednesday 26 March 2008 16:16:57 you wrote:
> select ('134987'::int/1000.00) * interval ' 1 second' ;
> ?column?
> --
> 00:02:14.987
> (1 row)
Thanks Adrian!
Wow!
Shawn
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
h
Hello,
I have several large tables, over 100 million records each. One of the fields
is callee 'duration'. It is a varchar that contains what is essentially an
integer that is the duration of an event in milleseconds. Could someone tell
me a simple way to convert a value such as 134987 store
11 matches
Mail list logo
