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 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');'
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
suggestions for a work around?
Shawn
