On Jan 25, 2006, at 10:12 , Foster, Stephen wrote:
> If I try to save without which was what I did in the first place I
> receive this using "ExpireDate := (date StartDate + integer
> NumOfDays);"
>
> ERROR: syntax error at or near "$1" at character 16
> QUERY: SELECT (date $1 + integer $2 )
> CONTEXT: SQL statement in PL/PgSQL function "TF_BannerAd_Ads_InsMod"
> near line 8
The common ways of casting in PostgreSQL are some_value::some_type,
e.g., "ExpireDate"::date, or using CAST, e.g., CAST ("ExpireDate" as
date). In the general case, some_type some_value will not work.
The docs can also be very helpful. I myself just looked up the syntax
of the CAST expression (I generally use the double-colon method).
See if that makes a difference.
Michael Glaesemann
grzm myrealbox com