This is a multipart message in MIME format.
------=_NextPart_000_02DC_01C89A3F.CB6A2F10
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hi,
I am trying to write a function, and have written this :
var_params_shootingstar :=
$v$
WHERE
(
t1.status = TRUE,
AND (
(
(
SELECT
z( pointn(
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$
),
AND (
$v$ || var_ratio_cartype_rain || $v$ <=
10
)
)
$v$;
RAISE NOTICE 'Where clause : %',
quote_literal(var_params_shootingstar);
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
of test
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
Matthew
_____
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!
------=_NextPart_000_02DC_01C89A3F.CB6A2F10
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml"
=
xmlns=3D"http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
..shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@[EMAIL PROTECTED]
"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@[EMAIL PROTECTED]
15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
..MsoChpDefault
{mso-style-type:ex****t-only;
font-size:10.0pt;}
@[EMAIL PROTECTED]
Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><span lang=3DEN-GB>Hi,<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB>I am trying to write a function, =
and have
written this :<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB>
var_params_shootingstar :=3D <o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB>
$v$<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
WHERE<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
(<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
t1.status =3D TRUE,<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
AND (<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp;
(<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp;
(<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp; &n=
bsp;
SELECT<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp; &n=
bsp;
z( pointn( geometryn(d3.the_geom,1), 1) ) AS z<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp; &n=
bsp;
FROM streets_3d d3<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp; &n=
bsp;
WHERE d3.gid =3D t1.gid <o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp;
) / $v$ || var_rain_cm || $v$<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp;
) >=3D $v$ || var_ratio_car_rain || $v$<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp;
),<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp;
AND ( <o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp;
$v$ || var_ratio_cartype_rain || $v$ <=3D 10<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
&=
nbsp;
) <o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
)<o:p></o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> =
$v$;<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span =
lang=3DEN-GB> RAISE
NOTICE 'Where clause : %', =
quote_literal(var_params_shootingstar);<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB>Instead of $v$ I also tried =
$vps$ and
‘ . I also tried removing quote_literal() to no =
avail.<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB>My problem is that I get : =
NOTICE:
Where clause : <NULL> when I try to execute the function. =
<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB>I tried changing it to
var_params_shootingstar :=3D $v$ this is a test $v$ || var_rain_cm =
|| $v$
end of test $v$;<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB>And this is the result I got :
NOTICE: Where clause : this is a test 0 end of =
test<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB>BTW : var_params_shootingstar is =
declared
as TEXT.<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB>I know this is a very strange =
problem,
hence why I am asking here, been trying different things for more than =
an hour.<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB>Any help is extremely =
appreciated.<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB>Thanks and =
regards<o:p></o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB><o:p> </o:p></span></p>
<p class=3DMsoNormal><span lang=3DEN-GB>Matthew<o:p></o:p></span></p>
<p class=3DMsoNormal><span style=3D'font-size:12.0pt;font-family:"Times =
New Roman","serif"'><o:p> </o:p></span></p>
<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><span
style=3D'font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=3D2 width=3D"100%" align=3Dcenter>
</span></div>
<p class=3DMsoNormal><span style=3D'font-size:12.0pt;font-family:"Times =
New Roman","serif"'>I
am using the free version of SPAMfighter for private users.<br>
It has removed 26496 spam emails to date.<br>
Paying users do not have this message in their emails.<br>
Try <a href=3D"http://www.spamfighter.com/len">SPAMfighter</a>
for free =
now!<o:p></o:p></span></p>
</div>
</body>
</html>
------=_NextPart_000_02DC_01C89A3F.CB6A2F10--
|
