Can I use LIKE to achieve the following result

[Yan Cheng Cheok <yccheok@xxxxxxxxx>]

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


      


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general