backslash separated values for a field

From: "surabhi(dot)ahuja" <surabhi(dot)ahuja(at)iiitb(dot)ac(dot)in>
To: <pgsql-general(at)postgresql(dot)org>
Subject: backslash separated values for a field
Date: 2006-02-10 11:54:10
Message-ID: 967CFC4343BF2A4DAFACD026D33DC85118ECBE@jal.iiitb.ac.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

i have a field "x" which can be of the form

abc\def\123

i.e. they are back slash separated fields

is there any operator in postgres which can process a query like give me all xs where x is abc

is ther any opeartor like contain, so i can form a query of the form:

select * from table_name where x contains 'abc';

thanks,
regards

Surabhi

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Leif B. Kristensen 2006-02-10 11:57:52 Re: backslash separated values for a field
Previous Message Pandurangan R S 2006-02-10 11:43:47 Re: r trim of characters other than space