how to filter pipe symbol

From: midde sirisha <sirishamidde(at)yahoo(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: how to filter pipe symbol
Date: 2001-10-23 06:52:12
Message-ID: 20011023065212.113.qmail@web8101.in.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi my problem is how to filter data using special
character like pipe symbol "|"

when i use a select statement like

select * from table where columname='hur|hg^*('

i am getting error
please guide me how to solve this problem
thanking you

____________________________________________________________
*NEW* Connect to Yahoo! Messenger through your mobile phone *NEW*
Visit http://in.mobile.yahoo.com/smsmgr_signin.html

Browse pgsql-general by date

  From Date Subject
Next Message Herbert Liechti 2001-10-23 06:55:23 Re: UNION bug in 7.1.3?
Previous Message Nikola Milutinovic 2001-10-23 06:48:51 Re: Problems setting up PostgreSQL and Tomcat JDBC connection