Re: [GENERAL] regarding contains operator

2006-03-08 Thread Tom Lane
"surabhi.ahuja" <[EMAIL PROTECTED]> writes: > 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) To be blunt, this is a really poorly-chosen data representation. To point out just one problem, ba

Re: [GENERAL] regarding contains operator

2006-03-08 Thread Michael Fuhr
On Wed, Mar 08, 2006 at 03:13:40PM +0530, surabhi.ahuja wrote: > please tell me is there any operator available which enables me to do the > following: > > field contains > > eg field contains "abc" should return true, similary for def or tez See "Pattern Matching" in the "Functions and Oper

Re: [GENERAL] regarding contains operator

2006-03-08 Thread Ragnar
On mið, 2006-03-08 at 15:13 +0530, surabhi.ahuja wrote: > > 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 http://www.postgresql.org/docs/8.1/interactive/extend.html http://www.postgresql.org/docs/8.1/interactive/

[GENERAL] regarding contains operator

2006-03-08 Thread surabhi.ahuja
 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   eg field contains "abc" should return