Search code examples
ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view depends on ...


postgresqlviewdependenciessqldatatypes

Read More
Creating Materialized view in PG 17 ignores data types in SELECT...


sqlpostgresqltype-conversioncasesqldatatypes

Read More
How to declare DATALINK type? FOREIGN DATA WRAPPER in Postgresql...


sqlpostgresql-9.1sqldatatypes

Read More
SQL: Is it efficient to use tinyint instead of Integer if my max value is 255?...


sqlsql-serverintegersqldatatypestinyint

Read More
How can I store a very big integer as a string in SQLite3 to an existing column with INTEGER affinit...


sqlitesqldatatypes

Read More
What is difference between storing data in a blob, vs. storing a pointer to a file?...


mysqlblobsqldatatypes

Read More
Boolean Field in Oracle...


oracle-databasebooleansqldatatypes

Read More
Varchar or Text Data Types for strings length up to few thousands of chars...


mysqlsqldatatypes

Read More
What is the difference between varchar and varchar2 in Oracle?...


oracle-databasesqldatatypes

Read More
How to get a list column names and datatypes of a table in PostgreSQL?...


sqlpostgresqlsqldatatypes

Read More
Why SUM(`column`) returns a string instead of an integer?...


phpmysqlpdosumsqldatatypes

Read More
Crypto Currency MySQL Datatypes ?...


mysqlsqlcurrencysqldatatypes

Read More
What is the PostgreSQL Equivalent of Oracle's FLOAT(126)?...


postgresqlsqldatatypes

Read More
What is the maximum precision of the double and float datatypes in MySQL...


mysqlfloating-pointdoublesqldatatypes

Read More
What is the difference between Number(38,127), Number, Number(*) and Number(*,127) in Oracle...


oracle-databasesqldatatypes

Read More
Postgres: how to excecute the query for Sum as it is giving error?...


sqlpostgresqlsqldatatypes

Read More
Best data type to store money values in MySQL...


mysqlsqldatatypescurrency

Read More
Appropriate datatype for holding percent values?...


sql-servertypessqldatatypes

Read More
How to store a boolean value in an Informix database?...


booleaninformixsqldatatypes

Read More
Reliable way to detect an INTEGER column using JDBC (Oracle 19c)...


oracle-databasejdbcsqldatatypesoracle19c

Read More
SQL Server: IN ('asd') not working when column is NTEXT...


sql-servert-sqlsql-server-2005sqldatatypesin-operator

Read More
What's the purpose of varchar(0)...


mysqlsqlsqldatatypes

Read More
Which data type is the result of division?...


postgresqlsqldatatypes

Read More
MySQL: Is there a lack of performance by using LONGTEXT instead of MEDIUMTEXT?...


mysqlperformancesqldatatypes

Read More
Store UUID v4 in MySQL...


mysqluuidsqldatatypes

Read More
Why doesn't SQL Server support unsigned datatype?...


sqlsql-serversqldatatypesunsigned-integer

Read More
Change datatype varchar to nvarchar in existing SQL Server 2005 database. Any issues?...


sqlsql-serversql-server-2005sqldatatypes

Read More
Is it OK to use the DEC data type in PostgreSQL...


postgresqlsqldatatypes

Read More
Conversion failed when converting the varchar to data type int when inserting multiple items...


sql-servert-sqltype-conversionsqldatatypes

Read More
Unable to alter column data type in Big Query...


google-bigquerysqldatatypes

Read More
BackNext