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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
