Re: LIKE multiple

On 9/14/06, Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> Gregorio Diaz escribió:
> > Hola lister(at)s
> >
> > Alguien sabe porque esto no funciona:
> >
> > SELECT nombre FROM personas WHERE nombre LIKE ('gr%',
> > 'al%', 'pe%')
>
> Porque no es legal segun SQL. Esto si:
>
> select * from personas where nombre any ~~ (array['gr%', 'al%', 'pe%']);
>

o

select * from personas where substring(nombre from 1 for 2) in ('gr',
'al', 'pe')

--
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook