Function To Strip HTML - Mailing list pgsql-sql

<div class="WordSection1"><p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">I have the following function that I used in MSSQL.  I
wouldlike to create the same function in PostgreSql.   I think I am a bit confused on how to create and set variables
inPostgreSql.  Can someone give me a place to start to create something like this?  </span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue"> </span><p
class="MsoNormal"style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier
New";color:blue"> </span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">Thanks</span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue"> </span><p
class="MsoNormal"style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier
New";color:blue">Pam</span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue"> </span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue">SET</span><span
style="font-size:10.0pt;font-family:"CourierNew""> <span style="color:blue">ANSI_NULLS</span> <span
style="color:blue">ON</span></span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">GO</span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue"> </span><p
class="MsoNormal"style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier
New";color:blue">SET</span><spanstyle="font-size:10.0pt;font-family:"Courier New""> <span
style="color:blue">QUOTED_IDENTIFIER</span><span style="color:blue">ON</span></span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue">GO</span><p
class="MsoNormal"style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier
New";color:blue"> </span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">CREATE</span><span
style="font-size:10.0pt;font-family:"CourierNew""> <span style="color:blue">FUNCTION</span> [dbo]<span
style="color:gray">.</span>[udf_StripHTML]</span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:gray">(</span><span style="font-size:10.0pt;font-family:"Courier
New"">@HTMLText<span style="color:blue">VARCHAR</span><span style="color:gray">(</span><span
style="color:fuchsia">MAX</span><spanstyle="color:gray">))</span></span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue">RETURNS</span><span
style="font-size:10.0pt;font-family:"CourierNew""> <span style="color:blue">VARCHAR</span><span
style="color:gray">(</span><spanstyle="color:fuchsia">MAX</span><span style="color:gray">)</span></span><p
class="MsoNormal"style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier
New";color:blue">AS</span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">BEGIN</span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue">DECLARE</span><span
style="font-size:10.0pt;font-family:"CourierNew""> @Start <span style="color:blue">INT</span></span><p
class="MsoNormal"style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier
New";color:blue">DECLARE</span><spanstyle="font-size:10.0pt;font-family:"Courier New""> @End <span
style="color:blue">INT</span></span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">DECLARE</span><span
style="font-size:10.0pt;font-family:"CourierNew""> @Length <span style="color:blue">INT</span></span><p
class="MsoNormal"style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier
New";color:blue">SET</span><spanstyle="font-size:10.0pt;font-family:"Courier New""> @Start <span
style="color:gray">=</span><span style="color:fuchsia">CHARINDEX</span><span style="color:gray">(</span><span
style="color:red">'<'</span><spanstyle="color:gray">,</span>@HTMLText<span style="color:gray">)</span></span><p
class="MsoNormal"style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier
New";color:blue">SET</span><spanstyle="font-size:10.0pt;font-family:"Courier New""> @End <span
style="color:gray">=</span><span style="color:fuchsia">CHARINDEX</span><span style="color:gray">(</span><span
style="color:red">'>'</span><spanstyle="color:gray">,</span>@HTMLText<span style="color:gray">,</span><span
style="color:fuchsia">CHARINDEX</span><spanstyle="color:gray">(</span><span style="color:red">'<'</span><span
style="color:gray">,</span>@HTMLText<spanstyle="color:gray">))</span></span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue">SET</span><span
style="font-size:10.0pt;font-family:"CourierNew""> @Length <span style="color:gray">=</span><span style="color:blue">
</span><spanstyle="color:gray">(</span>@End <span style="color:gray">-</span> @Start<span style="color:gray">)</span>
<spanstyle="color:gray">+</span> 1</span><p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">WHILE</span><span
style="font-size:10.0pt;font-family:"CourierNew""> @Start <span style="color:gray">></span> 0</span><p
class="MsoNormal"style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier
New";color:gray">AND</span><spanstyle="font-size:10.0pt;font-family:"Courier New""> @End <span
style="color:gray">></span>0</span><p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:gray">AND</span><span
style="font-size:10.0pt;font-family:"CourierNew""> @Length <span style="color:gray">></span> 0</span><p
class="MsoNormal"style="text-autospace:none"><span style="font-size:10.0pt;font-family:"Courier
New";color:blue">BEGIN</span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">SET</span><span
style="font-size:10.0pt;font-family:"CourierNew""> @HTMLText <span style="color:gray">=</span> <span
style="color:fuchsia">STUFF</span><spanstyle="color:gray">(</span>@HTMLText<span style="color:gray">,</span>@Start<span
style="color:gray">,</span>@Length<spanstyle="color:gray">,</span><span style="color:red">''</span><span
style="color:gray">)</span></span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">SET</span><span
style="font-size:10.0pt;font-family:"CourierNew""> @Start <span style="color:gray">=</span> <span
style="color:fuchsia">CHARINDEX</span><spanstyle="color:gray">(</span><span style="color:red">'<'</span><span
style="color:gray">,</span>@HTMLText<spanstyle="color:gray">)</span></span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue">SET</span><span
style="font-size:10.0pt;font-family:"CourierNew""> @End <span style="color:gray">=</span> <span
style="color:fuchsia">CHARINDEX</span><spanstyle="color:gray">(</span><span style="color:red">'>'</span><span
style="color:gray">,</span>@HTMLText<spanstyle="color:gray">,</span><span style="color:fuchsia">CHARINDEX</span><span
style="color:gray">(</span><spanstyle="color:red">'<'</span><span style="color:gray">,</span>@HTMLText<span
style="color:gray">))</span></span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">SET</span><span
style="font-size:10.0pt;font-family:"CourierNew""> @Length <span style="color:gray">=</span><span style="color:blue">
</span><spanstyle="color:gray">(</span>@End <span style="color:gray">-</span> @Start<span style="color:gray">)</span>
<spanstyle="color:gray">+</span> 1</span><p class="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">END</span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue">RETURN</span><span
style="font-size:10.0pt;font-family:"CourierNew""> <span style="color:fuchsia">LTRIM</span><span
style="color:gray">(</span><spanstyle="color:fuchsia">RTRIM</span><span style="color:gray">(</span>@HTMLText<span
style="color:gray">))</span></span><pclass="MsoNormal" style="text-autospace:none"><span
style="font-size:10.0pt;font-family:"CourierNew";color:blue">END</span><p class="MsoNormal"
style="text-autospace:none"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue"> </span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Courier New";color:blue">GO</span><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"></span><pclass="MsoNormal"><span
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> </span></div>