不区分大小写的数据库 [英] case-insensitive database
问题描述
有没有办法让Postgresql案例 - INSENSITIVE？
谢谢
Is there a way to make Postgresql case-INSENSITIVE?
Thanks
推荐答案
Quoth"松弛素QUOT; < no **** @ spam.com>：
Quoth "Relaxin" <no****@spam.com>:
有没有办法让Postgresql案例 - INSENSITIVE？
Is there a way to make Postgresql case-INSENSITIVE?
已经是。
portfolio = #select * from stocks limit 1;
symbol |描述|交换
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
投资组合=＃sELeCT *来自股票限价1;
符号|描述|交换
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
这些查询的设置不同，但被认为是
在功能上相同。
-
output =（" aa454"" @""" freenet.carleton.ca"）
http://cbbrowne.com/info/linux.html
debugging，v：
从大海捞针上取下针。
It already is.
portfolio=# select * from stocks limit 1;
symbol | description | exchange
--------+-------------+----------
AADBX | AADBX | NYSE
(1 row)
portfolio=# sELeCT * FROM STOCKS LIMIT 1;
symbol | description | exchange
--------+-------------+----------
AADBX | AADBX | NYSE
(1 row)
Those queries were cased differently, but were recognized as being
functionally identical.
--
output = ("aa454" "@" "freenet.carleton.ca")
http://cbbrowne.com/info/linux.html
debugging, v:
Removing the needles from the haystack.
Quoth" Relaxin" < no **** @ spam.com>：
Quoth "Relaxin" <no****@spam.com>:
有没有办法让Postgresql案例 - INSENSITIVE？
Is there a way to make Postgresql case-INSENSITIVE?
已经是。
portfolio = #select * from stocks limit 1;
symbol |描述|交换
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
投资组合=＃sELeCT *来自股票限价1;
符号|描述|交换
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
这些查询的设置不同，但被认为是
在功能上相同。
-
output =（" aa454"" @""" freenet.carleton.ca"）
http://cbbrowne.com/info/linux.html
debugging，v：
从大海捞针上取下针。
It already is.
portfolio=# select * from stocks limit 1;
symbol | description | exchange
--------+-------------+----------
AADBX | AADBX | NYSE
(1 row)
portfolio=# sELeCT * FROM STOCKS LIMIT 1;
symbol | description | exchange
--------+-------------+----------
AADBX | AADBX | NYSE
(1 row)
Those queries were cased differently, but were recognized as being
functionally identical.
--
output = ("aa454" "@" "freenet.carleton.ca")
http://cbbrowne.com/info/linux.html
debugging, v:
Removing the needles from the haystack.
不，我指的是数据。
select *来自股票的符号='''AADBX''
和
选择*来自股票，其中symbol =''aadbx''
将显示相同的结果集。
Christopher Browne < CB ****** @ acm.org>在消息中写道
news：m3 ************ @ chvatal.cbbrowne.com ...
No, I mean the data.
select * from stocks where symbol = ''AADBX''
and
select * from stocks where symbol = ''aadbx''
would bring up the same result set.
"Christopher Browne" <cb******@acm.org> wrote in message
news:m3************@chvatal.cbbrowne.com...
Quoth" Relaxin" < no **** @ spam.com>：
Quoth "Relaxin" <no****@spam.com>:
有没有办法让Postgresql案例 - INSENSITIVE？
Is there a way to make Postgresql case-INSENSITIVE?
它已经是。
投资组合= #select *来自股票限价1;
符号|描述|交流
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
组合=＃sELeCT *来自股票上涨1;
符号|描述|交流
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
这些查询的设置不同，但被认为在功能上相同。
-
output =（" aa454"" @""" freenet.carleton.ca"）
http://cbbrowne.com/info/linux.html
调试，v：
从大海捞针上取下针。
It already is.
portfolio=# select * from stocks limit 1;
symbol | description | exchange
--------+-------------+----------
AADBX | AADBX | NYSE
(1 row)
portfolio=# sELeCT * FROM STOCKS LIMIT 1;
symbol | description | exchange
--------+-------------+----------
AADBX | AADBX | NYSE
(1 row)
Those queries were cased differently, but were recognized as being
functionally identical.
--
output = ("aa454" "@" "freenet.carleton.ca")
http://cbbrowne.com/info/linux.html
debugging, v:
Removing the needles from the haystack.
这篇关于不区分大小写的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
