Home > mailing lists

backslash separated values for a field - Mailing list pgsql-general

From	surabhi.ahuja
Subject	backslash separated values for a field
Date	February 10, 2006 10:50:58
Msg-id	967CFC4343BF2A4DAFACD026D33DC85118ECBE@jal.iiitb.ac.in Whole thread Raw
Responses	Re: backslash separated values for a field
List	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

From: Pandurangan R S
Date: 10 February 2006, 10:43:46
Subject: Re: r trim of characters other than space

From: "Leif B. Kristensen"
Date: 10 February 2006, 10:57:59
Subject: Re: backslash separated values for a field