DAP Relational Database Server II: Difference between revisions

From OPeNDAP Documentation
⧼opendap2-jumptonavigation⧽
Line 89: Line 89:
|}
|}


== Table test 2 ==
== PostgreSQL Data Types ==
 
{| border="1" cellspacing="0"
{| border="1" cellspacing="0"
|+  PostgreSQL Data Types (from [http://www.faqs.org/docs/ppbook/x2632.htm Practical PostgreSQL])
|+  Boolean and Binary Types  
!Catagory !! Data Type  !! Description !! Standardization || Logical DAP data type association.
! Data Type  !! Description !! Standardization || Logical DAP data type association.
|-
|-
| Boolean and binary types
| boolean, bool ||  A single true or false value. || SQL99 || Boolean
|
{| border="1" cellspacing="0"
| boolean, bool  
|-
| bit(n)
|-
| bit varying(n), varbit(n)
|}
|
{| border="1" cellspacing="0"
|-
|  A single true or false value.  
|-
| An n -length bit string (exactly n binary bits).
|-
| A variable n -length bit string (up to n binary bits)
|}
|
{| border="1" cellspacing="0"
|-
| SQL99
|-
| SQL92
|-
| SQL92
|}
|
{| border="1" cellspacing="0"
|-
| Boolean
|-
|-
| ''None''
| bit(n) || An n -length bit string (exactly n binary bits). || SQL92 || ''None''
|-
|-
| ''None''
| bit varying(n), varbit(n) || A variable n -length bit string (up to n binary bits) || SQL92 || ''None''
|}
|}
|}


Revision as of 18:17, 21 April 2009

Introduction

Previous Design/Implementation

Data model representation

Atomic (Simple) Types

Table Test 1

Transact-SQL (Microsoft)
Type Range Storage Bytes DAP equiv.
bigint 8 bytes none
int 4 bytes
numeric
decimal
bit
smallint 2 bytes
tinyint 1 bytes
smallmoney
money
float 4 or 8 bytes
real 4 bytes
date
datetimeoffset
datetime2
smalldatetime
datetime
time
char
varchar
next
nchar
nvarchar
ntext
binary
varbinary
image
cursor
timestamp
hierarchyid
uniquieidentifier
sql_variant
xml
table

PostgreSQL Data Types

Boolean and Binary Types
Data Type Description Standardization Logical DAP data type association.
boolean, bool A single true or false value. SQL99 Boolean
bit(n) An n -length bit string (exactly n binary bits). SQL92 None
bit varying(n), varbit(n) A variable n -length bit string (up to n binary bits) SQL92 None

Desired Features

Implementation Target

Retrieved from "https://docs.opendap.org/index.php?title=DAP_Relational_Database_Server_II&oldid=3729"