Using a parameter in Interval
От | Davidson, Robert |
---|---|
Тема | Using a parameter in Interval |
Дата | |
Msg-id | 8333C841129E074E9F83FC80676BA76E0BEBEF@exchg-sea3-03.ant.amazon.com обсуждение исходный текст |
Ответы |
Re: Using a parameter in Interval
(Michael Glaesemann <grzm@myrealbox.com>)
Re: Using a parameter in Interval (Stephan Szabo <sszabo@megazone.bigpanda.com>) |
Список | pgsql-sql |
<p align="LEFT"><span lang="en-us"><font face="Arial" size="2">No matter how I try to concatenate, I can</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2">’</font></span><span lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2">t seem to get a parameter to be used by INTERVAL in a function:</font></span><palign="LEFT"><span lang="en-us"><font face="Arial" size="2">CREATE OR REPLACE FUNCTION Testing(TrailingWeeksint) RETURNS date AS $$</font></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2">BEGIN</font></span><palign="LEFT"><span lang="en-us"> <font face="Arial" size="2">RETURN current_date - INTERVAL(CAST(TrailingWeeks AS varchar) || ' weeks');</font></span><p align="LEFT"><span lang="en-us"><font face="Arial"size="2">END;</font></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2">$$ LANGUAGE plpgsql;</font></span><palign="LEFT"><span lang="en-us"><font face="Arial" size="2">--</font></span><span lang="en-us"></span><spanlang="en-us"><font face="Arial" size="2">select * from testing(1);</font></span><span lang="en-us"></span><spanlang="en-us"></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2">ERROR: syntaxerror at or near "CAST" at character 34</font></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2">QUERY: SELECT current_date - INTERVAL (CAST( $1 AS varchar) || ' weeks')</font></span><p align="LEFT"><span lang="en-us"><fontface="Arial" size="2">CONTEXT: SQL statement in PL/PgSQL function "testing" near line 2</font></span><spanlang="en-us"></span><span lang="en-us"></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2">Ihave tried concatenating it as a declared variable (with and without apostrophes)</font></span><p align="LEFT"><spanlang="en-us"><font face="Arial" size="2">1 weeks</font></span><p align="LEFT"><span lang="en-us"><fontface="Arial" size="2">And </font></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2">‘</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2">1 weeks</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Arial" size="2">’</font></span><span lang="en-us"></span><spanlang="en-us"></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2">With no success.Any tips?</font></span><p align="LEFT"><span lang="en-us"><font face="Arial" size="2">Many thanks,</font></span><palign="LEFT"><span lang="en-us"><font face="Arial" size="2">Robert</font></span><span lang="en-us"></span><spanlang="en-us"></span>
В списке pgsql-sql по дате отправления:
Предыдущее
От: Scott MarloweДата:
Сообщение: Re: Referential integrity broken (8.0.3), sub-select help