I am trying to write a function, and have written this :
t1.status = TRUE,
geometryn(d3.the_geom,1), 1) ) AS z
FROM streets_3d d3
WHERE d3.gid = t1.gid
) / $v$ || var_rain_cm || $v$
) >= $v$ || var_ratio_car_rain || $v$
$v$ || var_ratio_cartype_rain || $v$ <=
RAISE NOTICE 'Where clause : %',
Instead of $v$ I also tried $vps$ and ' . I also tried removing
quote_literal() to no avail.
My problem is that I get : NOTICE: Where clause : <NULL> when I try to
execute the function.
I tried changing it to var_params_shootingstar := $v$ this is a test $v$
|| var_rain_cm || $v$ end of test $v$;
And this is the result I got : NOTICE: Where clause : this is a test 0 end
BTW : var_params_shootingstar is declared as TEXT.
I know this is a very strange problem, hence why I am asking here, been
trying different things for more than an hour.
Any help is extremely appreciated.
Thanks and regards
I am using the free version of SPAMfighter for private users.
It has removed 26496 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter <http://www.spamfighter.com/len> for free now!
pgsql-novice by date
|Next:||From: Terry Lee Tucker||Date: 2008-04-09 10:59:05|
|Subject: Re: Text Variable in a Function|
|Previous:||From: Raimon Fernandez||Date: 2008-04-09 06:59:48|
|Subject: warnings restoring a db|