On Wed, Mar 26, 2008 at 5:45 PM, Shawn <postgres(at)xmtservices(dot)net> 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 '1 msec');
$$
language sql
immutable
returns null on null input;