Skip site navigation (1) Skip section navigation (2)

SELECT from a list

From: Keith Gallant <keith(at)justhosting(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: SELECT from a list
Date: 2004-07-25 13:18:17
Message-ID: PDENIKIKNMLHOJKGJDLGCEPCCGAA.keith@justhosting.ca (view raw or flat)
Thread:
Lists: pgsql-sql
Hello

I am wondering if it is possible to use a SINGLE LIKE statement for a
selection from a list.

For example: If I want to return all results that a phrase starts with a
number, can I make a call similar to the following:

SELECT * FROM table WHERE phrase LIKE
{'0%','1%','2%','3%','4%','5%','6%','7%','8%','9%'};

If not is there an easier way than having to call this:

SELECT * FROM table WHERE phrase LIKE '0%' OR phrase LIKE '1%' OR phrase
LIKE '2%' OR phrase LIKE '3%' OR phrase LIKE '4%' OR phrase LIKE '5%' OR
phrase LIKE '6%' OR phrase LIKE '7%' OR phrase LIKE '8%' OR phrase LIKE
'9%';

Thank you.

Keith



Responses

pgsql-sql by date

Next:From: Markus BertheauDate: 2004-07-25 13:56:20
Subject: Re: SELECT from a list
Previous:From: Tom LaneDate: 2004-07-24 16:13:19
Subject: Re: Trigger functions with dynamic SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group