logo       

Re: plug-n-play MS SQL Server replacement: msg#00166

db.postgresql.advocacy

Subject: Re: plug-n-play MS SQL Server replacement

Quoth josh@xxxxxxxxxxxx (Josh Berkus):
> Also, if you have T-SQL procedures, you would have to somehow implement T-SQL
> for Postgres; translating the procedures is really not an option.

You would be hit by a lot of other similar sorts of "impedances" to
those found with MySQL.

Most conspicuously, MySQL is most likely an imitator of Sybase
(progenitor of the code that Microsoft sells) in having
"autoincrementing columns" as compared to PostgreSQL's notion of
"sequence objects."
--
wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','ntlug.org').
http://cbbrowne.com/info/spreadsheets.html
Monday is an awful way to spend one seventh of your life. -- Unknown

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend



<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise