Differences

This shows you the differences between two versions of the page.

--- cloud:aws:dynamodb [2023/07/11 18:35] – skipidar
+++ cloud:aws:dynamodb [2023/11/01 07:13] (current) – ↷ Page moved from business_process_management:camunda:cloud:aws:dynamodb to cloud:aws:dynamodb skipidar
@@ Line 5: / Line 5: @@
 The following table lists the data types you can use with PartiQL for DynamoDB.
-| Boolean |TRUE | FALSE | 	Not case sensitive. |
+| Boolean | ''TRUE / FALSE'' | Not case sensitive. |
-| Binary |N/A | 	Only supported via code. |
+| Binary | ''N/A'' | Only supported via code. |
-| List | [ value1, value2,...] | There are no restrictions on the data types that can be stored in a List type, and | the elements in a List do not have to be of the same type. |
+| List | ''[ value1, value2,...]'' | There are no restrictions on the data types that can be stored in a List type, and  the elements in a List do not have to be of the same type. |
-| Map	| { 'name' : value } | There are no restrictions on the data types that can be stored in a Map type, and | the elements in a Map do not have to be of the same type. |
+| Map	| ''{ 'name' : value }'' | There are no restrictions on the data types that can be stored in a Map type, and  the elements in a Map do not have to be of the same type. |
-| Null | NULL	|  Not case sensitive. |
+| Null | ''NULL''	|Not case sensitive. |
-| Number |1, 1.0, 1e0 | 	Numbers can be positive, negative, or zero. Numbers can have up to 38 digits of precision. |
+| Number | ''1, 1.0, 1e0'' | Numbers can be positive, negative, or zero. Numbers can have up to 38 digits of precision. |
-| Number | Set |<<number1, number2>> | 	The elements in a number set must be of type Number. |
+| Number Set | ''<<number1, number2>>'' | The elements in a number set must be of type Number. |
-| String Set | <<'string1', 'string2'>> | 	The elements in a string set must be of type String. |
+| String Set | ''<<'string1', 'string2'>>'' | The elements in a string set must be of type String. |
-| String | 'string value' | Single quotes must be used to specify String values. |
+| String | '''string value''' | Single quotes must be used to specify String values. |
+<code>
+INSERT INTO TypesTable value {'primarykey':'1',
+'NumberType':1,
+'MapType' : {'entryname1': 'value', 'entryname2': 4},
+'ListType': [1,'stringval'],
+'NumberSetType':<<1,34,32,4.5>>,
+'StringSetType':<<'stringval','stringval2'>>
+}
+</code>