pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kretschmer Andreas <andreas_kretschmer@despammed.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: [despammed] How to search for a subString
Date: Sun, 6 Feb 2005 16:11:45 +0100
Message-ID: <20050206151145.GA4865@kaufbach.delug.de> (raw)
In-Reply-To: <20050206160348.059c695b.postgresql@finner.de>
References: <20050206101246.28648.qmail@web61003.mail.yahoo.com>
	<20050206104520.GA3405@kaufbach.delug.de>
	<20050206133220.GB952@wolff.to>
	<20050206160348.059c695b.postgresql@finner.de>

am  Sun, dem 06.02.2005, um 16:03:48 +0100 mailte Frank Finner folgendes:
> Do REs automatically ignore case? Otherwise it is clear that ~ 'the

No.


> fast' cannot find 'The fast and the furious'. The search
> expressions should be all uppercased or lowercased then.

Correct.

~  : Case-sensitive
~* : ignore case

!~ and !~* are negative


Regards, Andreas
-- 
Diese Message wurde erstellt mit freundlicher Unterstützung eines freilau-
fenden Pinguins aus artgerechter Freilandhaltung.   Er ist garantiert frei
von Micro$oft'schen Viren. (#97922 http://counter.li.org)     GPG 7F4584DA
Was, Sie wissen nicht, wo Kaufbach ist? Hier: N 51.05082°, E 13.56889° ;-)



view thread (7+ messages)  latest in thread

Message-ID: <20050206151145.GA4865@kaufbach.delug.de>
Permalink:  ../20050206151145.GA4865@kaufbach.delug.de/
Also on:    postgresql.org/message-id/20050206151145.GA4865@kaufbach.delug.de

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: andreas_kretschmer@despammed.com
  Subject: Re: [despammed] How to search for a subString
  In-Reply-To: <20050206151145.GA4865@kaufbach.delug.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox