Introduction Cast is a technique in PostgreSQL with which we can convert a value of one datatype into another. We can perform various cast operations in PostgreSQL for converting one datatype to another, such as the String datatype to the Integer datatype (or the Boolean datatype or datetime datatype) and vice versa. This article will […]
2021-01-21
968 reads
We sometimes need to perform a different/alternative actions during database queries. We need it for data protection or data abstraction. The PostgreSQL rule system allows to define an alternative action on insert, update or delete. A rule generates an extra query. As a result, rule execution impacts the performance of the system. Creating Rules A […]
2020-12-03
1,703 reads
Apache TinkerPop is an open source graph computing framework. A graph computing network is a set of vertices and edges in the network. If we compare a graph database to traditional relational databases, we can assume that every row in a table of a relational database is equivalent to a vertex in graph network. Similarly, […]
2020-10-15
2,814 reads
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
When you don't have statistics, what does SQL use to calculate the estimated number...
By Ed Elliott
This is a bit of a longer one, a look at how to do...
Below is data in which two different date are coming,01/19/2021 and 01/18/2021 , Date...
I have a requirement whereby testers on ServerA need a copy of the production...
I need to get value portion key to every 3 row on one row...
Ask SSC