Our application will be switched from SQL Server to PostgreSQL. However, a few functions are not supported yet. So we decided to extend it.
The functions are as following:
1.SQL statement support INSERT statement without INTO keyword DELETE statement without FROM keywork 2.Build-in function SQUARE CHAR CHARINDEX LEN REPLICATE SPACE STR STUFF CONVERT DATALENGTH DATEADD DATEDIFF DATEPART DAY MONTH YEAR EOMONTH GETDATE SYSDATETIME 3.Operator operator !< (Not Less Than) operator !> (Not Greater Than) operator + (String Concatenation) 4.Other DataType support(smalldatetime,datetime,datatime2,uniqueidentifer) Date, Time, and Timestamp Escape Sequences ODBC Scalar Functions OCTET_LENGTH CURRENT_DATE CURRENT_TIME
The extended functions are almost completed but your opinion is very important to us. Would you please help us to review the extended source?