https://www.sqlines.com/ 2026-04-18T14:20:03+00:00 https://www.sqlines.com/ https://www.sqlines.com/lib/images/favicon.ico text/html 2013-08-26T13:07:59+00:00 https://www.sqlines.com/informix-to-postgresql/data_validation?rev=1377522479&do=diff SQLines Data tool helps you validate the data transfer from Informix to PostgreSQL after the database migration. Row Count Check The fastest and simplest way that can help reveal critical problems in data migration is to check the number of rows in corresponding Informix and PostgreSQL tables. text/html 2013-09-20T11:22:32+00:00 https://www.sqlines.com/informix-to-postgresql/grant?rev=1379676152&do=diff Both Informix and PostgreSQL provide the GRANT statement to assign access privileges to users and roles, but there are differences in the syntax. * Execute a Procedure or Function * Use Languages Privileges to Execute Stored Procedures and Functions Grant execute permission on a stored procedure or function in Informix: text/html 2013-10-12T15:46:27+00:00 https://www.sqlines.com/informix-to-postgresql/interval_minute_to_minute?rev=1381592787&do=diff In Informix INTERVAL MINUTE TO MINUTE data type stores a time interval in minutes. As a data type it just stores an integer value, but when you cast any interval value (INTERVAL DAY TO SECOND i.e.) to ::INTERVAL MINUTE TO MINUTE, you get the total number of minutes in the interval. text/html 2013-10-12T15:43:00+00:00 https://www.sqlines.com/informix-to-postgresql/interval_second_to_second?rev=1381592580&do=diff In Informix INTERVAL SECOND TO SECOND data type stores a time interval in seconds. As a data type it just stores an integer value, but the most interesting thing about this data type is that when you cast any interval value (INTERVAL DAY TO SECOND i.e.) to ::INTERVAL SECOND TO SECOND, you get the total number of seconds in the interval. text/html 2013-08-26T10:37:48+00:00 https://www.sqlines.com/informix-to-postgresql/null_order_by?rev=1377513468&do=diff In Informix, when you sort columns in ORDER BY clause NULL values go first for ascending order, and last for descending order. In PostgreSQL, the default behavior is different, NULL values go last for ascending order, and first for descending order, but PostgreSQL allows you to specify NULLS FIRST and NULLS LAST clauses in ORDER BY to specify sorting for NULL values text/html 2022-10-16T17:20:20+00:00 https://www.sqlines.com/informix-to-postgresql/outer?rev=1665940820&do=diff Informix supports the specific OUTER clause in the FROM clause of the SELECT statement to define the outer joins. It has to be converted to ANSI SQL outer join syntax in PostgreSQL. Consider the following tables with sample data: CREATE TABLE cities (name VARCHAR(30), country VARCHAR(30)); CREATE TABLE countries (name VARCHAR(30), capital VARCHAR(30), region VARCHAR(30)); CREATE TABLE regions (name VARCHAR(30), continent VARCHAR(30)); -- Cities INSERT INTO cities VALUES ('Malag… text/html 2013-08-26T10:38:34+00:00 https://www.sqlines.com/informix-to-postgresql/string_sorting_order?rev=1377513514&do=diff When you migrate an Informix database to PostgeSQL you may notice differences in the results of queries that use sorting (ORDER BY clause). Let's consider an example. Informix: Default codepage 819 (Latin 1 ISO-8859-1) CREATE TABLE words (name VARCHAR(30)); -- Sample data INSERT INTO words VALUES ('Apple'); INSERT INTO words VALUES ('air'); INSERT INTO words VALUES ('Box'); -- Now let's run a query ordering rows SELECT name FROM words ORDER BY name; text/html 2024-07-18T12:23:35+00:00 https://www.sqlines.com/informix-to-postgresql/zero_char_code_in_string?rev=1721305415&do=diff PostgreSQL does not allow you to insert the character with code zero (ASCII NUL) to CHAR, VARCHAR or TEXT columns regardless of the specific character set. Informix does not have such limitation: Informix: -- Sample table CREATE TABLE items ( c1 CHAR(10) ); INSERT INTO items VALUES ('a' || CHR(0) || 'b'); # 1 row created. -- Review inserted data SELECT ASCII(SUBSTRING(c1 FROM 1 FOR 1)), ASCII(SUBSTRING(c1 FROM 2 FOR 1)), ASCII(SUBSTRING(c1 FROM 3 …