Re: [PATCH] Add mssql_compat extension with DATEDIFF function

Hi út 25. 11. 2025 v 21:15 odesílatel Peter Eisentraut napsal: > On 25.11.25 04:25, Myles Lewis wrote: > > I'd like to propose a new contrib extension: mssql_compat, which provides > > SQL Server compatible date functions starting with DATEDIFF. > > I think this could best live as an external pr

Re: [PATCH] Add mssql_compat extension with DATEDIFF function

On Tue, Nov 25, 2025 at 09:15:37PM +0100, Peter Eisentraut wrote: > I think this could best live as an external project. Likely so. Looking at the patch, everything written in it does not depend directly on something external, with all the function internals being written based on Postgres APIs.

Re: [PATCH] Add mssql_compat extension with DATEDIFF function

On 25.11.25 04:25, Myles Lewis wrote: I'd like to propose a new contrib extension: mssql_compat, which provides SQL Server compatible date functions starting with DATEDIFF. I think this could best live as an external project. orafce is a similar project but for Oracle. There might also be oth

[PATCH] Add mssql_compat extension with DATEDIFF function

I'd like to propose a new contrib extension: mssql_compat, which provides SQL Server compatible date functions starting with DATEDIFF. Problem: PostgreSQL lacks a native DATEDIFF() function, forcing users to write verbose date arithmetic. Organizations migrating from SQL Server encounter frictio