In PostgreSQL, we can use the RETURNING clause to return data that was modified during an UPDATE, INSERT, or DELETE operation. This allows us to see the data that was modified without having to perform a separate query to retrieve that data.
what is
PostgreSQL DATE_BIN() Function Explained
In PostgreSQL, the DATE_BIN() function enables us to “bin” a timestamp into a given interval aligned with a specific origin. In other words, we can use this function to map (or force) a timestamp to the nearest specified interval.
This can be handy when we want to truncate a timestamp to a given interval, for example a 10 minute interval. We can specify the interval (e.g. 10 minutes, 15 minutes, 30 minutes, etc), and we can specify the starting point for the interval. Therefore, we can have the interval starting at any odd time we want (it doesn’t need to start on the hour or anything like that).
Redis HINCRBYFLOAT Command
The Redis HINCRBYFLOAT command increments the field in the hash at the specified key by a floating point number. We specify how much we want the field to increment by when we call the command.
Redis HINCRBY Command
The Redis HINCRBY command increments the number that’s stored at the specified field in the hash at the specified key. We specify how much we want the field to increment by when we call the command.
Redis HVALS Command
The Redis HVALS command returns all values in the hash stored at the specified key.
Redis HLEN Command
The Redis HLEN command returns the number of fields in the hash stored at the specified key.
Redis HGETALL Command
The Redis HGETALL command returns all fields and values from the hash at the specified key.
Redis HMGET Command
The Redis HMGET command allows us to get multiple values from a hash. It returns the value/s associated with the specified field/s in the hash at the specified key.
Redis HGET Command
The Redis HGET command allows us to get a value from a hash. It returns the value associated with the specified field in the hash at the specified key.
Redis HRANDFIELD Command
The Redis HRANDFIELD command allows us to get a random field from a given key.
The command accepts several arguments that allows us to specify the number of random fields returned, whether to include the same field multiple times, and whether or not to include the values with each field returned.
The HRANDFIELD command was introduced in Redis 6.2.0.