Hacker News new | past | comments | ask | show | jobs | submit login

Using SQL Server exclusively has given me a Never-Oracle mindset. Some of these differences sound insane. and

> any functions in the order by clause must be moved to the select statement (e.g. order by lower(column_name))

I'd pull the hair outta my head




My top 1 is this one:

> Oracle: uses IS NULL to check for empty string; in postgres, empty string and null are different

Any programmer who doesn’t distinguish NULL and "" has not passed the 2-year experience. Being generous. How did this make it to production?


Do you mean why does Oracle treat NULL and empty string as the same thing? Internally Oracle changes empty string to NULL values. Oracle won't let you insert an empty string.


But functions in the where clause are an unsargable mess :(




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: