Re: [SQL] Function To Strip HTML

2011-02-23 Thread Ozer, Pam
27;\3'), E'(?x)(< [^>]*? >)', '', 'g') 3$$ LANGUAGE SQL; From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql-ow...@postgresql.org] On Behalf Of Ozer, Pam Sent: Wednesday, February 23, 2011 3:41 PM To: pgsql-sql@postgresql.org Subject: [SQL] Fun

[SQL] Function To Strip HTML

2011-02-23 Thread Ozer, Pam
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_NULL