Re: Postgres for SQL Server users

From: Ravi Krishna <ravi_krishna(at)aol(dot)com>
To: adambrusselback(at)gmail(dot)com
Cc: ronljohnsonjr(at)gmail(dot)com, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres for SQL Server users
Date: 2019-05-06 21:56:25
Message-ID: 1446815315.858684.1557179785091@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2019-05-06 22:44:06 Re: Postgres for SQL Server users
Previous Message Adam Brusselback 2019-05-06 21:48:33 Re: Postgres for SQL Server users