pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Kevin Houle <kevin@houle.org>
To: Jordan Reiter <jordan@breezing.com>
Subject: Re: Case Sensitive "WHERE" Clauses?
Date: Fri, 27 Sep 2002 23:38:29 -0400
Message-ID: <3D952435.4050207@houle.org> (raw)
References: <a05100312b9b8f9c321b3@[63.172.201.5]>

Jordan Reiter wrote:
> Are string comparisons in postgresql case sensitive?
> 
> I keep on having this response:
> 
> SELECT *
> FROM People
> WHERE first_name='jordan'
> 
> Result: 0 records
> 
> SELECT *
> FROM People
> WHERE first_name='Jordan'
> 
> Result: 1 record

It's case-sensitive. You can do this:

SELECT *
FROM People
WHERE lower(first_name) = 'jordon'

Kevin




view thread (13+ messages)

Message-ID: <3D952435.4050207@houle.org>
Permalink:  ../3D952435.4050207@houle.org/
Also on:    postgresql.org/message-id/3D952435.4050207@houle.org

 · 

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-sql@postgresql.org
  Cc: kevin@houle.org, jordan@breezing.com
  Subject: Re: Case Sensitive "WHERE" Clauses?
  In-Reply-To: <3D952435.4050207@houle.org>

* 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