From: | "PostgreSQL" <pgsql(at)brazilinfo(dot)com> |
---|---|
To: | "pgsql-general" <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] LIKE operator |
Date: | 1999-04-23 23:01:58 |
Message-ID: | 001201be8ddd$5fcb4b40$0300000a@cpqivx-2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If it really has to do with the version, then I cannot do anything about
it...
My ISP runs version 6.3, and they will always be a little bit not
up-to-date.
Thanks a lot,
Paulo
pparola(at)brazilinfo(dot)com
-----Mensagem original-----
De: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Para: PostgreSQL <pgsql(at)brazilinfo(dot)com>
Cc: pgsql-general(at)postgreSQL(dot)org <pgsql-general(at)postgreSQL(dot)org>
Data: Sexta-feira, 23 de Abril de 1999 17:56
Assunto: Re: [GENERAL] LIKE operator
>[Charset iso-8859-1 unsupported, filtering to ASCII...]
>> Hi,
>>
>> With mSQL I used to perform queries like below from within PHP:
>>
>> select field1, field2 from table1 where field1 like '%$some_variable%'
>>
>> where the '%' in the LIKE clause matches 0 or more characters of any
value.
>> That is, the query above would match the strings that contain
>> '$some_variable' OR any string if $some_variable is empty.
>>
>> For example: my table has two rows with the first record containing
>> field1='abc' and the second record containing field1='cde'.
>>
>> If '$some_variable' is empty, then my query would return both rows.
>> If $some_variable='bc', then the query would return only the row where
>> field1='abc'.
>>
>> With PostgreSQL I experience the following:
>>
>> If '$some_variable' is empty, then my query returns *nothing*.
>> If $some_variable='bc', then the query would return only the row where
>> field1='abc'.
>>
>> As the value of '$some_variable' is to be filled by some user while
posting
>> a form, I don't know in advance if it is going to be empty or not.
>>
>> How can I make the query results to be exactly as with mSQL without
having
>> to alter my query 'throwing out' every part of the 'where' clause where
>> '$some_variable' is empty?
>>
>
>With 6.5 beta, I get:
>
> test=> create table t (x text);
> CREATE
> test=> insert into t values ('abc');
> INSERT 18697 1
> test=> insert into t values ('bcd');
> INSERT 18698 1
> test=> select * from t where x like '%%';
> x
> ---
> abc
> bcd
> (2 rows)
>
>Not sure what 6.4 does, but I will say I overhauled the LIKE code in
>6.5beta.
>
>
>--
> Bruce Momjian | http://www.op.net/~candle
> maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | JP Rosevear | 1999-04-24 22:28:58 | [Fwd: [HACKERS] typeidTypeRelid Error] |
Previous Message | Bruce Momjian | 1999-04-23 20:55:40 | Re: [GENERAL] LIKE operator |