Re: Using regular expressions in LIKE

Hi Terry,
thanks for your ansver. I've already read this page but I couldn't find out
if I can do such things or not. And if I can than how. So if you can suggest
me some additional manual pages regarding regular expressions can be used in
LIKE statements, please write me.

I don't know where to find it in the manual... :(

Thank you very much,
-- Csaba Együd

> -----Original Message-----
> From: terry(at)greatgulfhomes(dot)com [mailto:terry(at)greatgulfhomes(dot)com]On
> Behalf Of terry(at)ashtonwoodshomes(dot)com
> Sent: 2004. január 14. 12:51
> To: csegyud(at)vnet(dot)hu; 'Pgsql-General(at)Postgresql(dot)Org (E-mail)'
> Subject: RE: [GENERAL] Using regular expressions in LIKE
>
>
> Don't be afraid to read the manual:
>
> http://www.postgresql.org/docs/current/static/functions-matchi
> ng.html#FUNCTI
> ONS-SQL99-REGEXP
>
> http://www.postgresql.org/docs/current/static/functions-matchi
> ng.html#FUNCTI
> ONS-POSIX-REGEXP
>
> Terry Fielder
> Manager Software Development and Deployment
> Great Gulf Homes / Ashton Woods Homes
> terry(at)greatgulfhomes(dot)com
> Fax: (416) 441-9085
>
>
> > -----Original Message-----
> > From: pgsql-general-owner(at)postgresql(dot)org
> > [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Együd Csaba
> > Sent: Wednesday, January 14, 2004 6:43 AM
> > To: Pgsql-General(at)Postgresql(dot)Org (E-mail)
> > Subject: [GENERAL] Using regular expressions in LIKE
> >
> >
> > Hi All,
> > I'd like to "compress" the following two filter expressions
> into one -
> > assuming that it makes sense regarding query execution performance.
> >
> > ... where (adate LIKE "2004.01.10 __:30" or adate LIKE
> > "2004.01.10 __:15")
> > ...
> >
> > into something like this:
> >
> > ... where adate LIKE "2004.01.10 __:(30/15)" ...
> >
> > which means that I need only those rows which has an "adate"
> > field holding
> > dates on 2004.01.10 every 30 or 15 minutes at the end. Is it
> > possible to use
> > some regular expressions or is it worth at all talking about?
> >
> > thanks,
> > -- Csaba
> >
> > ----------------------------------------
> > Együd Csaba
> > csegyud(at)vnet(dot)hu
> > IN-FO Studio Bt.
> > tel/fax: +36-23-545-447, +36-23-382-447
> > mobil: +36-23-343-8325
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 8: explain analyze is your friend
> >
>
> -- Incoming mail is certified Virus Free.
> Checked by AVG Anti-Virus (http://www.grisoft.com)
> Version: 7.0.211 / Virus Database: 261 - Release Date: 2004. 01. 13.
>