MSSQL Query and Function convert to PostgreSQL
- PROCEDURE -> FUNCTION AND RETURN VOID;
CREATE OR REPLACE FUNCTION <function name> (value)
RETURNS void AS
$$
BEGIN
<Procedure body>
END;
$$ LANGUAGE plpgsql VOLATILE;
-
Data type
- nvarchar -> varchar
TOP -> LIMIT
-
IF
- MSSQL : IF condition BEGIN function END;
- PostgreSQL : IF condition THEN function END IF;
DYNAMIC SQL
MSSQL: EXEC query;
PSQL:
EXEC SQL BEGIN DECLARE SECTION;
EXEC SQL BEGIN DECLARE SECTION;
const char *stmt = "CREATE TABLE test1 (...);";
EXEC SQL END DECLARE SECTION;
EXEC SQL EXECUTE IMMEDIATE :stmt;