> 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.