Re: [GENERAL] How to convert MS SQL functions to pgSQL functions

2016-12-31 Thread Thomas Kellerer
Yogi Yang 007 schrieb am 31.12.2016 um 11:06: Hello, I am stuck while trying to convert/port a MS SQL server database to pgSQL. Here is the code of the function in MS SQL server: CREATE FUNCTION [dbo].[AccountGroupHierarchy] -- Description: ( @groupId numeric(18,0) ) RETURNS @table_variable

[GENERAL] How to convert MS SQL functions to pgSQL functions

2016-12-31 Thread Yogi Yang 007
Hello, I am stuck while trying to convert/port a MS SQL server database to pgSQL. Here is the code of the function in MS SQL server: CREATE FUNCTION [dbo].[AccountGroupHierarchy] -- Description: statement> ( @groupId numeric(18,0) ) RETURNS @table_variable TABLE (accountGroupId NUMERIC(18,0))