From: | "Ansley, Michael" <Michael(dot)Ansley(at)intec(dot)co(dot)za> |
---|---|
To: | "'Constantin Teodorescu '" <teo(at)flex(dot)ro>, "'Hannu Krosing '" <hannu(at)tm(dot)ee> |
Cc: | "'PostgreSQL Interfaces '" <pgsql-interfaces(at)postgresql(dot)org> |
Subject: | RE: [INTERFACES] Case insensitive LIKE ? |
Date: | 1999-10-31 19:31:29 |
Message-ID: | 1BF7C7482189D211B03F00805F8527F748C1E1@S-NATH-EXCH2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Hi, Constantin,
I'll be very surprised if you can get the whole lot to work without using
IFs. Access is markedly non-SQL compliant. It pushes the term 'extended
sub-set' to the limit, both the 'extended', and the 'sub' bits. I work with
Access and Oracle at work, and everything has to either be done for Access,
or Oracle. Not to appear negative or anything...
I have just tried Access now, and it doesn even know what % is. It seems to
hand the like clause to the underlying engine for evaluation, when I tried
it with an Oracle linked table, it was quite happy, case-sensitive and all.
With a native Access table, it wasn't interested in the slightest.
So, that might point to a difference in the ODBC drivers' implementation and
handling of regexes.
MikeA
-----Original Message-----
From: Constantin Teodorescu
To: Hannu Krosing
Cc: PostgreSQL Interfaces
Sent: 99/10/31 02:30
Subject: Re: [INTERFACES] Case insensitive LIKE ?
Hannu Krosing wrote:
>
> Constantin Teodorescu wrote:
> >
> > Is there for PostgreSQL a modifier(parameter) that will make the
LIKE
> > clause case insensitive ?
>
> Maybe
>
> select * from t where lower(name) like 'john%';
Yes, it may work, but probably lower(name) won't work on ODBC->MS Access
...
I would like to preserve also the SQL commands betwen versions and not
to fill my program with IF's ..
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIA
************
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 1999-10-31 20:31:22 | RE: [INTERFACES] Case insensitive LIKE ? |
Previous Message | Tom Lane | 1999-10-31 17:29:55 | Re: [INTERFACES] Case insensitive LIKE ? |