> I suspect that's a pretty non-standard/rarely-used feature though. If you learn SQL you likely won't encounter this Recursive common table expressions are part of the SQL standard (since 1999) and are quite frequently…
> PostgreSQL has built in support for UUIDv4 through the pgcrypto or the uuid-ossp extensions. Since Postgres 13 installing an extension is no longer necessary as gen_random_uuid() is part of the core.
Yes, it matters. Many Postgres features aren't supported on Redshift (set returning functions, indexes, ...) and many tools that work just fine with Postgres error out because Redshift does things differently or doesn't…
> rather than Redshift Despite what the Amazon marketing is telling, Redshift is not really a "fork" of Postgres. To my knowledge they only used the SQL parser and the wire protocol from Postgres. The optimizer, query…
You need to use pg_dump from the new version, not from the old version.
> It sounds like Russia might get declared a terrorist state soon. Lithuania has apparently already done that.
I have been working with Oracle for more than 20 years now. I think I only had very few situations where an "index organized table" (=clustered index) was useful or actually provided a major performance benefit over a…
> Without dura, you use Ctrl-Z in your editor to get back to a good state. I just turn on "Local History" in my NetBeans IDE which creates a new version of the file each time I save it. No need to use Ctrl-Z for that.
You don't have to do that "manually". Postgres supports the conversion using the `at time zone` operator.
Did you try Qwant? https://www.qwant.com/maps
select extract(month from justify_interval(timestamp '2022-01-01' - timestamp '2021-11-01')) returns 2
Well for "counting buckets" you can use `date_bin()` since Postgres 14 which groups the difference between timestamps into defined intervals.
But the difference between 2021-01-01 and 2020-12-31 is only one day, not a year. It gets even strange for e.g. select DATEDIFF(year, '2021-12-01', '2022-01-01') which still returns 1 even though that's a whole month. I…
> For example, find all users who have have been active at least 10 days. Well, then you only need to compare the difference of the timestamp (or date) values with an interval of 10 days. e.g. end_time - start_time >=…
> No, for example, the datediff in years for New Year's Eve and New Year's Day should be 1 I don't understand the purpose of such a calculation. If you want to check if two dates (or timestamps) fall into the same year,…
The question is: what do you do with the result? If you e.g. want to check if two timestamps are more than a year apart you just compare the difference to an interval of 1 year.
The "distance" between two dates seems quite useful. In Postgres there is no need for a datediff() function - you would just subtract the two dates: date '2021-01-01' - date '2020-12-31'
I never understood the need for a datediff function. In Postgres (or Oracle) you just subtract two timestamps and use the resulting interval. It's a different approach to the same problem.
"hundreds" of concurrent connections isn't really a problem for Postgres. Several thousands are - at least up until now. V14 will improve this substantially.
There about 10 issues logged with Bugzilla regarding this. All closed as "wontfix"
Only helps until the next release. Then all customization options where you can turn off Proton will be removed.
The new bookmark menus are simply terrible. The use much more space than before. I even have one that needs scrolling now. And it's not possible to use the "compact" layout anymore. You can enable the menu item, but the…
You shouldn't see downvoting as a personal attack. It's simply a way to express disagreement with the statement. How else would one signal agreement or disagreement if not by up- or downvoting? Would you rather have…
Ages ago I installed a shareware product. And it also had a scrollable "terms and condition" screen (about 2 pages long) when starting it for the first time. When you clicked the "I Agree" button too quickly it would…
So I should pay $50 dollar just to read one article? (And pay for a foreign currency transfer on top of that?) There is no option to read the article without signing up for one year subscription. From a link shared on a…
> I suspect that's a pretty non-standard/rarely-used feature though. If you learn SQL you likely won't encounter this Recursive common table expressions are part of the SQL standard (since 1999) and are quite frequently…
> PostgreSQL has built in support for UUIDv4 through the pgcrypto or the uuid-ossp extensions. Since Postgres 13 installing an extension is no longer necessary as gen_random_uuid() is part of the core.
Yes, it matters. Many Postgres features aren't supported on Redshift (set returning functions, indexes, ...) and many tools that work just fine with Postgres error out because Redshift does things differently or doesn't…
> rather than Redshift Despite what the Amazon marketing is telling, Redshift is not really a "fork" of Postgres. To my knowledge they only used the SQL parser and the wire protocol from Postgres. The optimizer, query…
You need to use pg_dump from the new version, not from the old version.
> It sounds like Russia might get declared a terrorist state soon. Lithuania has apparently already done that.
I have been working with Oracle for more than 20 years now. I think I only had very few situations where an "index organized table" (=clustered index) was useful or actually provided a major performance benefit over a…
> Without dura, you use Ctrl-Z in your editor to get back to a good state. I just turn on "Local History" in my NetBeans IDE which creates a new version of the file each time I save it. No need to use Ctrl-Z for that.
You don't have to do that "manually". Postgres supports the conversion using the `at time zone` operator.
Did you try Qwant? https://www.qwant.com/maps
select extract(month from justify_interval(timestamp '2022-01-01' - timestamp '2021-11-01')) returns 2
Well for "counting buckets" you can use `date_bin()` since Postgres 14 which groups the difference between timestamps into defined intervals.
But the difference between 2021-01-01 and 2020-12-31 is only one day, not a year. It gets even strange for e.g. select DATEDIFF(year, '2021-12-01', '2022-01-01') which still returns 1 even though that's a whole month. I…
> For example, find all users who have have been active at least 10 days. Well, then you only need to compare the difference of the timestamp (or date) values with an interval of 10 days. e.g. end_time - start_time >=…
> No, for example, the datediff in years for New Year's Eve and New Year's Day should be 1 I don't understand the purpose of such a calculation. If you want to check if two dates (or timestamps) fall into the same year,…
The question is: what do you do with the result? If you e.g. want to check if two timestamps are more than a year apart you just compare the difference to an interval of 1 year.
The "distance" between two dates seems quite useful. In Postgres there is no need for a datediff() function - you would just subtract the two dates: date '2021-01-01' - date '2020-12-31'
I never understood the need for a datediff function. In Postgres (or Oracle) you just subtract two timestamps and use the resulting interval. It's a different approach to the same problem.
"hundreds" of concurrent connections isn't really a problem for Postgres. Several thousands are - at least up until now. V14 will improve this substantially.
There about 10 issues logged with Bugzilla regarding this. All closed as "wontfix"
Only helps until the next release. Then all customization options where you can turn off Proton will be removed.
The new bookmark menus are simply terrible. The use much more space than before. I even have one that needs scrolling now. And it's not possible to use the "compact" layout anymore. You can enable the menu item, but the…
You shouldn't see downvoting as a personal attack. It's simply a way to express disagreement with the statement. How else would one signal agreement or disagreement if not by up- or downvoting? Would you rather have…
Ages ago I installed a shareware product. And it also had a scrollable "terms and condition" screen (about 2 pages long) when starting it for the first time. When you clicked the "I Agree" button too quickly it would…
So I should pay $50 dollar just to read one article? (And pay for a foreign currency transfer on top of that?) There is no option to read the article without signing up for one year subscription. From a link shared on a…