postgresql 不支持 T-SQL

最新推荐文章于 2024-05-24 09:54:21 发布

最新推荐文章于 2024-05-24 09:54:21 发布 · 388 阅读

文章标签：

#SQL #PostgreSQL #Sybase #PHP

博客围绕从Sybase迁移应用到PostgreSQL展开，提到手册未提及对T - SQL的支持，对于迁移存储过程，建议在PostgreSQL的PL语言（如plpgsql、pltcl等）中重写。

http://archives.postgresql.org/pgsql-sql/2002-01/msg00247.php

Re: support for transact-sql?

--------------------------------------------------------------------------------

From: Stephan Szabo <sszabo ( at ) megazone23 ( dot ) bigpanda ( dot ) com>
To: Marius Andreiana <marius ( at ) wdg ( dot ) ro>
Subject: Re: support for transact-sql?
Date: Mon, 21 Jan 2002 13:01:59 -0800 (PST)

--------------------------------------------------------------------------------

On 21 Jan 2002, Marius Andreiana wrote:

> Hi
>
> I'm analyzing the possibility of porting our current applications from
> sybase to postgresql.
> I know the manual doesn't mention t-sql support.
> The only solution to migrate stored procedures is to rewrite each of
> them to use pl/pgsql?

You'd probably need to rewrite them in one of the postgres pl languages
(plpgsql, pltcl, ...)