Re: Can I use LIKE to achieve the following result

Something like this will be possible but your data sets are contradictory.
There is no
3 | Cat
Row in the original table..

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Yan Cheng Cheok
Sent: 20 January 2010 18:23
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Can I use LIKE to achieve the following result

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