Hi. You can return a set of record of that table with a sentence including the LIKE operator, i.e.
SELECT ID, Item FROM your_table WHERE item LIKE 'Car_'; and you would get this result: ID | Item ========= 0 | Car1 1 | Car2 2 | Car3 Take a look of the documentation in the postgresql documentation for pattern matching: http://www.postgresql.org/docs/8.3/interactive/functions-matching.html greets. Ricardo Ramirez 2010/1/20 Harry McCarney <hmccar...@dialecticit.com> > 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-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Yan Cheng Cheok > Sent: 20 January 2010 18:23 > To: pgsql-general@postgresql.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 > > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
