Function To Strip HTML

From: "Ozer, Pam" <pozer(at)automotive(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Function To Strip HTML
Date: 2011-02-23 23:41:06
Message-ID: 216FFB77CBFAEE4B8EE4DF0A939FF1D14F84C9@mail-001.corp.automotive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I have the following function that I used in MSSQL. I would like to
create the same function in PostgreSql. I think I am a bit confused on
how to create and set variables in PostgreSql. Can someone give me a
place to start to create something like this?

Thanks

Pam

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE FUNCTION [dbo].[udf_StripHTML]

(@HTMLText VARCHAR(MAX))

RETURNS VARCHAR(MAX)

AS

BEGIN

DECLARE @Start INT

DECLARE @End INT

DECLARE @Length INT

SET @Start = CHARINDEX('<',@HTMLText)

SET @End = CHARINDEX('>',@HTMLText,CHARINDEX('<',@HTMLText))

SET @Length = (@End - @Start) + 1

WHILE @Start > 0

AND @End > 0

AND @Length > 0

BEGIN

SET @HTMLText = STUFF(@HTMLText,@Start,@Length,'')

SET @Start = CHARINDEX('<',@HTMLText)

SET @End = CHARINDEX('>',@HTMLText,CHARINDEX('<',@HTMLText))

SET @Length = (@End - @Start) + 1

END

RETURN LTRIM(RTRIM(@HTMLText))

END

GO

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message manuel antonio ochoa 2011-02-24 00:03:26 Compare two Data bases Structure
Previous Message Emi Lu 2011-02-23 19:11:54 Re: quotes etc