问题描述
有没有办法让Postgresql案例 - INSENSITIVE？
谢谢
Is there a way to make Postgresql case-INSENSITIVE?
Thanks
推荐答案
已经是。
portfolio = #select * from stocks limit 1;
symbol |描述|交换
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
投资组合=＃sELeCT *来自股票限价1;
符号|描述|交换
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
这些查询的设置不同，但被认为是
在功能上相同。
-
output =（" aa454"" @""" freenet.carleton.ca"）
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.
已经是。
portfolio = #select * from stocks limit 1;
symbol |描述|交换
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
投资组合=＃sELeCT *来自股票限价1;
符号|描述|交换
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
这些查询的设置不同，但被认为是
在功能上相同。
-
output =（" aa454"" @""" freenet.carleton.ca"）
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 *来自股票限价1;
符号|描述|交流
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
组合=＃sELeCT *来自股票上涨1;
符号|描述|交流
-------- + ------------- + ----------
AADBX | AADBX |纽约证券交易所
（1排）
这些查询的设置不同，但被认为在功能上相同。
-
output =（" aa454"" @""" freenet.carleton.ca"）
调试，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.
这篇关于不区分大小写的数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！