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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
