pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gregory W Burnham <gburnham@sfu.ca>
To: pierre@desertmoon.com
To: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] Quickie
Date: Mon, 8 Feb 1999 13:56:09 -0800
Message-ID: <003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca> (raw)

select User_Email from <whatever your table name is> where User_Email ~*
'fubar';

I think, I haven't tried it yet.

Gregory W Burnham
Software Engineer
Excite Labs
Faculty Of Education
Simon Fraser University
Vancouver, B.C.
(604) 291 3615 ph
(604) 291 5679 fx
----- Original Message -----
From: <pierre@desertmoon.com>
To: <pgsql-sql@postgreSQL.org>
Sent: Monday, February 08, 1999 1:57 PM
Subject: [SQL] Quickie


>Hi all...here is a quickie for ya:
>
>Given:
>User_Email|User_ID
>-------------------
>fubar     | 1
>barfu     | 2
>snafu     | 3
>Fubar     | 4
>
>What query could I use to return ONLY 'fubar' and 'Fubar'? Would I do a
self
>join? The problem is that I'd forgotten to force everything to lowercase
upon
>insertion, and now I need to clean out the uppercase records and/or convert
them
>to lowercase.
>
>Ideas?
>
>-=pierre
>
>




view thread (3+ messages)  latest in thread

Message-ID: <003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca>
Permalink:  ../003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca/
Also on:    postgresql.org/message-id/003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: gburnham@sfu.ca, pierre@desertmoon.com
  Subject: Re: [SQL] Quickie
  In-Reply-To: <003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca>
  References: <003401be53ad$d60ee2e0$3d063a8e@educ.sfu.ca>

* 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