On Wednesday 26 March 2008 17:14:28 Tom Lane wrote:
> Or even easier:
> regression=# select 134987 * interval '1 msec';
> (1 row)
> regards, tom lane
Tom and Adrian,
i am trying to incorporate the solution you gave into a function, trying to
save some typing. Its keeps throwing a syntax error:
edacs=# create or replace function dur_interval_msec(char) returns interval
as 'select ($1 * interval '1 msec');'
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
suggestions for a work around?
In response to
pgsql-sql by date
|Next:||From: Rodrigo E. De León Plicet||Date: 2008-03-26 23:12:07|
|Subject: Re: FW: Re: Part 1 of several - Converting a varchar to an interval|
|Previous:||From: Adrian Klaver||Date: 2008-03-26 20:02:51|
|Subject: Re: FW: Re: Part 1 of several - Converting a varchar to an interval |