Re: Postgres for SQL Server users - Mailing list pgsql-general

From Ravi Krishna
Subject Re: Postgres for SQL Server users
Date
Msg-id 1446815315.858684.1557179785091@mail.yahoo.com
Whole thread Raw
In response to Postgres for SQL Server users  (Igal Sapir <igal@lucee.org>)
Responses Re: Postgres for SQL Server users
List pgsql-general
> I think the main "gotcha" when I moved from SQL Server to Postgres was 
> I didn't even realize the amount of in-line t-sql I would use to just get stuff done
> for ad-hoc analysis. 

T-SQL is an exceptionally powerful SQL based language.  Add to it, the many functions 
SS has. I recently had to write an equivalent of UNPIVOT. 

> Postgres doesn't have a good way to emulate this.

Yeah, no where close.



pgsql-general by date:

Previous
From: Adam Brusselback
Date:
Subject: Re: Postgres for SQL Server users
Next
From: Thomas Kellerer
Date:
Subject: Re: Postgres for SQL Server users