Reply to this topicStart new topicStart Poll

> postgresql安裝問題
魏孝政
發表於: Sep 12 2008, 19:09  
Quote Post


迪拉斯艦隊與荊揚軍樂團之間
************

發表數: 3,158
所屬群組: 一般
註冊日期: 9-18-2003

活躍:11
聲望:685


user posted image

無言,連就這樣只是按next的安裝都會有錯=_=

請教


--------------------
user posted image
PMEmail Poster
Top
徐元直
發表於: Sep 12 2008, 21:58  評價+1
Quote Post


攤抖首領
************

發表數: 7,913
所屬群組: 君主
註冊日期: 9-18-2003

活躍:59
聲望:4176


換成台灣或者UTF-8呢?


--------------------
......
PMEmail Poster
Top
魏孝政
發表於: Sep 13 2008, 08:38  
Quote Post


迪拉斯艦隊與荊揚軍樂團之間
************

發表數: 3,158
所屬群組: 一般
註冊日期: 9-18-2003

活躍:11
聲望:685


轉用台灣的確就可以了,感謝。


--------------------
user posted image
PMEmail Poster
Top
魏孝政
發表於: Sep 13 2008, 09:54  
Quote Post


迪拉斯艦隊與荊揚軍樂團之間
************

發表數: 3,158
所屬群組: 一般
註冊日期: 9-18-2003

活躍:11
聲望:685


One more question orz= =

By using pgAdmin. I created a new table and then set some columns inside the table.

One of the column. I set the datatype to 'money'.

And there is a problem about that, it seems deafult it to be "NT dollars"= =(maybe it is beacuse I set the locale to Taiwan???) ...... how can I change it back to HK dollars?

Thanks.


--------------------
user posted image
PMEmail Poster
Top
徐元直
發表於: Sep 13 2008, 11:05  
Quote Post


攤抖首領
************

發表數: 7,913
所屬群組: 君主
註冊日期: 9-18-2003

活躍:59
聲望:4176


It depends on the locale, I don't know how to change it otherwise.

By the way, monetary types in pgsql has the limit of +/- 21 million and the output format is inflexible. Even the official pgsql manual suggest you not to use it. They just put it there to maintain backward compatibility.

It's much better to use numeric or decimal type and process the I/O format within your program.


--------------------
......
PMEmail Poster
Top
魏孝政
發表於: Sep 13 2008, 14:22  
Quote Post


迪拉斯艦隊與荊揚軍樂團之間
************

發表數: 3,158
所屬群組: 一般
註冊日期: 9-18-2003

活躍:11
聲望:685


oops.....But anyway thank you very much.

I change the datatype of this column to numeric.

QUOTE
Even the official pgsql manual suggest you not to use it. They just put it there to maintain backward compatibility.

......

What an unnecessary datatype

Only one monetary type can be entry= =


--------------------
user posted image
PMEmail Poster
Top
1 位使用者正在閱讀本主題 (1 位訪客及 0 位匿名使用者)
0 位會員:

Topic Options Reply to this topicStart new topicStart Poll

 



[ Script Execution time: 0.0141 ]   [ 12 queries used ]   [ GZIP 啟用 ]