Tag: datatypes

Found 215 results for 'datatypes'.

1) postgresql - Does it make sense to store a couple of Boolean values as array?
2) postgresql - Should I add an arbitrary length limit to VARCHAR columns?
3) postgresql - PostgreSQL custom operator UUID to varchar
4) postgresql-9.3 - Working with PostgreSQL information_schema and tables (with same names, in different schemas) whose names start with a number
5) postgresql - PostgreSQL data type text vs varchar without length
6) postgresql - Help understanding behavior of try_cast() with numeric strings
7) datatypes - In Rails: How is existing data affected by data type change?
8) postgresql - Why does jsonb use more space for storing integers?
9) postgresql - postgresql operator negator usage
10) postgresql - PostgreSQL: Pass table as argument in function
11) postgresql - Use of ANY function for multiple values
12) postgresql - Using PostgreSQL what is the difference between a smallint and a bool for storing boolean?
13) postgresql - PostgreSQL extending a variable-width bit string type?
14) postgresql - What is the optimal data type for an MD5 field?
15) postgresql - Is 'internallength' always useful in custom type definition in Postgres?
16) mysql - Datatype for phone number: VARCHAR, INT or BIGINT?
17) oracle - Oracle Table Design, Storing Small Values
18) sql-server - Detect if any values in NVARCHAR columns are actually unicode
19) sql-server - Implicit conversion: when does it hurt performance a lot?
20) postgresql - Is there any slowdown in casting from varchar to text?
21) sql-server - Is there any performance implication from using varchar(max) over varchar(n) in cast/convert?
22) postgresql - What is the best way to store an email address in PostgreSQL?
23) mysql - Changing TEXT to VARCHAR
24) datatypes - Why database has char data type when varchar is more efficient?
25) postgresql - How exactly does the one-byte "char" type work in PostgreSQL?
26) postgresql - Postgresql 9.6 Error trying to have a function return a string without first casting it as a string.
27) mysql - MySQL loading NULLs in numeric columns
28) postgresql - PostgreSQL alternative to SQL Server’s `try_cast` function
29) postgresql - changing float->numeric casts from assignment to implicit, dangerous?
30) sql-server - Handling sql column with mixed varchar and float data types
31) postgresql - Mysterious inequality behavior when comparing date strings
32) postgresql - Is there any way in Postgres to parameterise a procedure for sort order column, when the columns are of different types?
33) mysql - How to compare (in MySQL) a DATETIME value to a TIMESTAMP value?
34) sql-server - Excel Import ID, Data Type Double
35) postgresql - What is the data type of the ‘ctid’ system column in Postgres?
36) mongodb - How to convert _id field of all existing documents from type String to Number
37) sql-server - Change column data type across database
38) postgresql - How to avoid implicit type casts in PostgreSQL?
39) sql-server - Why does using a Real data type in a mathematical equation return an incorrect result?
40) postgresql - Do fixed-width rows improve PostgreSQL read performance?
41) postgresql - Why does postgres use more space for a time with timezone than a timestamp with timezone?
42) postgresql - Single data type for imprecise date values, as allowed by ISO 8601
43) postgresql - Should Postgres function return/coerce numeric scale/precision?
44) sql-server - Why is datalength of decimal 5 regardless of precision?
45) postgresql - ERROR: "4.9E-324" is out of range for type double precision
46) postgresql - Postgres numeric type overflow after 1023 bisection of 1
47) sql-server - Changing varchar(max) to varchar(255) requires rebuilding table
48) postgresql - Why does a JSON element return text when it's not text?
49) mysql - Advantages and Disadvantages to using ENUM vs Integer types?
50) postgresql - PostgreSQL: cast row to type