Home > mailing lists

Re: any chance of "like ANY (array[])" like the "= ANY (array[])" syntax? - Mailing list pgsql-general

From	Greg Stark
Subject	Re: any chance of "like ANY (array[])" like the "= ANY (array[])" syntax?
Date	September 10, 2003 23:14:03
Msg-id	87brtsz17a.fsf@stark.dyndns.tv Whole thread Raw
In response to	Re: any chance of "like ANY (array[])" like the "= ANY (array[])" syntax? (Tom Lane <tgl@sss.pgh.pa.us>)
List	pgsql-general

Tree view

Tom Lane <tgl@sss.pgh.pa.us> writes:

> Greg Stark <gsstark@mit.edu> writes:
> > I find myself wishing I had a syntax "LIKE ANY (array['foo','bar'])".
>
> You do, because LIKE has an equivalent operator.
>
>     foo ~~ ANY (array[])

Yippee! Thanks.

--
greg

pgsql-general by date:

From: Guy Fraser
Date: 10 September 2003, 22:34:59
Subject: Re: Picture with Postgres and Delphi

From: "Marc G. Fournier"
Date: 11 September 2003, 00:39:45
Subject: Re: Release date

Re: any chance of "like ANY (array[])" like the "= ANY (array[])" syntax? - Mailing list pgsql-general

Previous

Next