• PostgreSQL Porting Guide
• General rules
• Problems and how to solve them
• The VARCHAR-NULL problem
• The DECODE/NVL2 functions problem
• The NVL function problem
• JOIN in ANSI syntax
• SELECT column AS alias
• Default cast to integer
• The sysdate problem
• Date arithmetics
• Triggers must return something
• Triggers mustn't touch old if they are on insert
• Procedure call from Hibernate
• ORDER BY expression in DISTINCT select
• Rownum problem
• Subquery with no alias
• Composite type accessing
• Concatenating of evr
• Global function evr_t_as_vre_simple
• No autonomous transactions
• NUMBER to NUMERIC
• Calling procedures
• SELECT UNIQUE
• TO_NUMBER function
• TO_DATE function
• DELETE without FROM
• DUAL table
• MINUS keyword
• Bind parameter with space
• Portable nextval
• Recursion with opened cursors
• Anonymous procedural SQL blocks, in Python (backend)
• Relation (table) does not exists
• Inserting / writing blob in Python (backend)