From: Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: Pgsql-sql@postgresql.org <Pgsql-sql@postgresql.org>
Subject: Re: What should this query match?
Date: Wed, 14 Sep 2005 13:09:22 +0200
Message-ID: <1126696162.3675.21.camel@Panoramix> (raw)
In-Reply-To: <200509141248.24909.peter_e@gmx.net>
References: <1126691657.3675.5.camel@Panoramix>
<200509141248.24909.peter_e@gmx.net>
On Wed, 2005-09-14 at 12:48 +0200, Peter Eisentraut wrote:
> These queries should return the same answer if the query does not contain the
> value 'Jan%' (or differently capitalized versions). I suspect that you are
> actually attempting to use % as a wild card, but none of your queries use a
> pattern matching operator, so I'd go back and check if your queries really
> are what you think they should be.
Indeed, I am looking for a wildcard query, getting all records that are
smaller than lowercase Jan*. From your remark I gather that this is not
the correct syntax ;-).
Could you give me an example? I understand that the following query
returns all matches but I want everything smalle than the match
SELECT COUNT(*) FROM prototype.customers
WHERE lower(lastName) ilike 'jan%'
TIA
--
Groeten,
Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl
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-sql@postgresql.org
Cc: J.Kraaijeveld@Askesis.nl, peter_e@gmx.net
Subject: Re: What should this query match?
In-Reply-To: <1126696162.3675.21.camel@Panoramix>
* 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