regarding contains operator - Mailing list pgsql-general

From surabhi.ahuja
Subject regarding contains operator
Date
Msg-id 8626C1B7EB748940BCDD7596134632BE398661@jal.iiitb.ac.in
Whole thread Raw
Responses Re: regarding contains operator  (Ragnar <gnari@hive.is>)
Re: regarding contains operator  (Michael Fuhr <mike@fuhr.org>)
Re: regarding contains operator  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
 i have a field whose type is varchar(16)
 
and the field is multivalued, in the sense it is of the form
 
abc\def\tez
(i.e. backslash separed values)
 
please tell me is there any operator available which enables me to do the following:
 
field contains <some value>
 
eg field contains "abc" should return true, similary for def or tez
 
if it is not ther can i write my own operators? abd use them please send me the link where i can find documnetation on the same
thanks,
regards
Surabhi Ahuja
 

pgsql-general by date:

Previous
From: Ken Johanson
Date:
Subject: Re: Perspective: PostgreSQL usage boon after release of
Next
From: Ragnar
Date:
Subject: Re: regarding contains operator