Thanks all for the help :)
I got to do all this, because there a existing system
running on SQL Server/SQL Anyway which using
all these syntax though out the coding, and I got to
make it support postgreSQL
And here is a question relate to the DataDiff function
in SQL Server, is it possible to write a function that pass
the parameter like the DataDiff function, I mean:
DataDiff( Year, date1, date2)
but not
DataDiff( 'Year', date1, date2)
Is it possible to doing this? Define a enum data type?
Thanks
Bill