Re: Using a parameter in Interval

On Mar 22, 2006, at 9:52 , Davidson, Robert wrote:

> ERROR:  syntax error at or near "CAST" at character 34
>
> QUERY:  SELECT  current_date - INTERVAL (CAST( $1  AS varchar) || '  
> weeks')
>
> CONTEXT:  SQL statement in PL/PgSQL function "testing" near line 2
The generally recommended way is something like:

test=# select '4'::integer * interval '1 week';
?column?
----------
28 days
(1 row)

or the more SQL compliant:

test=# select cast('4' as integer) * interval '1 week';
?column?
----------
28 days
(1 row)

Does that work for you?

Michael Glaesemann
grzm myrealbox com