Can I use LIKE to achieve the following result

From: Yan Cheng Cheok <yccheok(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Can I use LIKE to achieve the following result
Date: 2010-01-20 18:22:31
Message-ID: 682509.73286.qm@web65704.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harry McCarney 2010-01-20 18:58:20 Re: Can I use LIKE to achieve the following result
Previous Message Filip Rembiałkowski 2010-01-20 18:13:52 Re: About partitioning