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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Yan Cheng Cheok Sent: 20 January 2010 18:23 To: pgsql-general@xxxxxxxxxxxxxx Subject: 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
