Thread: Can I use LIKE to achieve the following result

Can I use LIKE to achieve the following result

From
Yan Cheng Cheok
Date:
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





Re: Can I use LIKE to achieve the following result

From
"Harry McCarney"
Date:
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@postgresql.org
[mailto:pgsql-general-owner@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



Re: Can I use LIKE to achieve the following result

From
Ricardo Fuentes
Date:
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:

2010/1/20 Harry McCarney <HMcCarney@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-owner@postgresql.org
[mailto:pgsql-general-owner@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