INT1? [英] int1?

查看:104
本文介绍了INT1?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

是否有任何日期类型可用于0-255

值?像int1一样或字节列。


CSN


__________________________________

你是Yahoo!?

新雅虎!购物 - 改进产品搜索
http://shopping.yahoo.com


---------------------------(广播结束)------- --------------------

提示7:别忘了增加免费空间地图设置

解决方案

CSN写道:

是否有可用于0-255的日期类型
值?像int1一样或者字节列。




你可以使用带约束的smallint。


HTH

Shridhar

---------------------------(广播结束)---------- -----------------

提示8:解释分析是你的朋友


< blockquote> On Thu,2003-10-09 at 02:16,CSN写道:

是否有任何日期类型可用于0-255
值?像int1一样或者字节列。




一个带有约束的int2。


-

-------------------------------------------------- ---------------

Ron Johnson,Jr。 ro *********** @ cox.net

美国路易斯安那州杰斐逊


"恐惧企鹅!!

---------------------------(播出结束)---- -----------------------

提示2:您可以使用取消注册命令一次性取消所有列表

(发送取消注册YourEmailAddressHere到 ma*******@postgresql.org


>是否有任何日期类型可用于0-255

值?像int1一样或字节列。




SMALLINT是磁盘上的两个字节,使用" char"代替。这是PostgreSQL中一个隐藏的

礼物,我希望通过更多

传统语法(*提示提示*)来展示。

http:// developer。 postgresql.org/docs...-SPECIAL-TABLE


-sc


-

Sean Chittenden


---------------------------(播出结束) - -------------------------

提示6:您是否搜索了我们的列表档案?
http://archives.postgresql.org


Is there any date type that can be used for 0-255
values? Like an "int1" or byte column.

CSN

__________________________________
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search
http://shopping.yahoo.com

---------------------------(end of broadcast)---------------------------
TIP 7: don''t forget to increase your free space map settings

解决方案

CSN wrote:

Is there any date type that can be used for 0-255
values? Like an "int1" or byte column.



You can use a smallint with constraint.

HTH
Shridhar
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend


On Thu, 2003-10-09 at 02:16, CSN wrote:

Is there any date type that can be used for 0-255
values? Like an "int1" or byte column.



An int2 with a constraint on it.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ro***********@cox.net
Jefferson, LA USA

"Fear the Penguin!!"
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)


> Is there any date type that can be used for 0-255

values? Like an "int1" or byte column.



A SMALLINT is two bytes on disk, use "char" instead. This is a hidden
goodie in PostgreSQL and one that I wish was exposed via a more
conventional syntax (*hint hint*).

http://developer.postgresql.org/docs...-SPECIAL-TABLE

-sc

--
Sean Chittenden

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


这篇关于INT1?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆