Pgcrypto extension - decrypt(encrypt(... not returning original data?

I tried to use the pgcrypto extension. from the manual. https://www.postgresql.org/docs/14/pgcrypto.html there are two functions - encrypt and decrypt - signatures as follows. encrypt(data bytea, key bytea, type text) returns bytea decrypt(data bytea, key bytea, type text) returns bytea OK. I

Re: Database Scalability

> > To my knowledge PostgreSQL doesn't support sharding, which is well and > > > > good because sharding is mostly useless, at least in my opinion. > Not only does PostgreSQL natively support table partitioning (which is > > absolutely a form of sharding), there multiple well-regarded extensio

Re: Understanding the differences between Temporal tables, CDC and Time Series.

Hi Peter, and thanks for answering. > > I'm unclear as to the "philosophical" distinctions here and would be > > grateful if anybody could explain the diffence(s) between them? > A time series database contains data records containing a time stamp > A temporal database contains records that

Understanding the differences between Temporal tables, CDC and Time Series.

Good morning to everyone, I'm looking into Temporal Tables (TT - i.e. System/Application time versioning) but I would like to understand the differences between TTs and two other features (which appear similar in many ways) - Change Data Capture and Time Series. Are Temporal Tables (in a sense

Settings for a new machine - some guidance sought.

Good afternoon everyone, I have a new laptop - running version 13.4 - simple binary from EnterpriseDB - no install! I plan to have a dual-boot machine - Windows 125 GB - have to be able to run Tableau which doesn't have a Linux desktop... Linux - the rest... Spec =

Re: Model clause and

That's Dimitri Fontaine - I don't know him personally and didn't mean to be impolite by referring to him by his first name - typo really! SQLP Sent with [ProtonMail](https://protonmail.com/) Secure Email. ‐‐‐ Original Message ‐‐‐ On Thursday, October 28th, 2021 at 20:

Model clause and

Good evening everybody. Are there any plans to emulate Oracle MODEL clause in PostgreSQL? If not, why not? It doesn't appear to have gained much traction even in the Oracle world? Also, are there any plans to introduce the MATCH_RECOGNIZE functionality? I read an interview with Dimitri and he

Re: Strange sequences - how to construct?

> --- example: lets get 3 sequences > > select next_sequence(), next_sequence(), next_sequence(); > --- inspect the table to see what happned > select * from my_sequence; Thanks for your input on this issue. SQLP Sent with ProtonMail Secure Email.

RE: Get COUNT results from two different columns

UNION-ed table, this is one and the same field and therefore cannot have two different names. HTH, SQL Padawan