Postgres Pro
Downloads
Home   >   mailing lists

Can I use LIKE to achieve the following result - Mailing list pgsql-general

From Yan Cheng Cheok
Subject Can I use LIKE to achieve the following result
Date
Msg-id 682509.73286.qm@web65704.mail.ac4.yahoo.com
Whole thread Raw
Responses Re: Can I use LIKE to achieve the following result  ("Harry McCarney" <HMcCarney@DialecticIT.com>)
List pgsql-general
Tree view 
I have the following original table :

ID | Item
=========
0  | Car1
1  | Car2
2  | Car3
3  | Cat1
4  | Cat2
5  | Cat3

I would like to return setof record, with the following :

ID | Item
=========
0  | Car1
1  | Car2
2  | Car3
3  | Cat

Is it possible to achieve using LIKE command?

Thanks and Regards
Yan Cheng CHEOK

pgsql-general by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: Re: About partitioning
Next
From: "Harry McCarney"
Date:
Subject: Re: Can I use LIKE to achieve the following result