Don't be afraid to read the manual: http://www.postgresql.org/docs/current/static/functions-matching.html#FUNCTI ONS-SQL99-REGEXP
http://www.postgresql.org/docs/current/static/functions-matching.html#FUNCTI ONS-POSIX-REGEXP Terry Fielder Manager Software Development and Deployment Great Gulf Homes / Ashton Woods Homes [EMAIL PROTECTED] Fax: (416) 441-9085 > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Együd Csaba > Sent: Wednesday, January 14, 2004 6:43 AM > To: [EMAIL PROTECTED] (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 > [EMAIL PROTECTED] > 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 > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
