sabyda

Senior application developer
  • Skills: Java, Spring boot, React, Azure, AWS, Postgres, Oracle, Websphere, Angular, Blockchain, Corda

SQLServerCentral Article

Array and Custom Data Types in PostgreSQL

Introduction Just like every other database, PostgreSQL has its own set of basic datatypes, like Boolean, Varchar, Text, Date, Time, etc. We can easily store data like numbers, characters, date, time, etc. using these supported datatypes, but what if we need to store multiple data elements in a single column? Suppose we are storing the […]

5 (2)

You rated this post out of 5. Change rating

2021-09-10

12,800 reads

SQLServerCentral Article

Conditional DELETE and INSERT in PostgreSQL

Introduction We are comfortable with inserting/deleting record(s) into/from a table. But we sometimes get confused when we need to insert or delete records conditionally from a table. Let us look at an example. Example scenario Suppose we have a table, called ALL_EMPLOYEES, which contains all employees' information who are working or had ever worked for […]

4.5 (2)

You rated this post out of 5. Change rating

2021-06-18 (first published: )

10,313 reads

SQLServerCentral Article

Getting a Query Execution Plan in PostgreSQL

Introduction You often need to check the performance of a PostgreSQL query you just wrote to look for some way to improve performance. In order to do this, you need a report of the query execution, which is called the execution plan). The query execution plan gives you the entire summary of the query execution […]

5 (2)

You rated this post out of 5. Change rating

2021-03-18

8,816 reads

SQLServerCentral Article

The CAST operator in PostgreSQL

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 […]

4.67 (3)

You rated this post out of 5. Change rating

2021-01-21

73,003 reads

SQLServerCentral Article

Rules in PostgreSQL

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 […]

5 (3)

You rated this post out of 5. Change rating

2020-12-03

8,685 reads

SQLServerCentral Article

Getting Started with Gremlin

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, […]

3.67 (3)

You rated this post out of 5. Change rating

2020-10-15

3,950 reads

Blogs

Big Queries, Big Money

By

I had been meaning to post this, so as I finished a piece that...

A New Word: Fardle-dun

By

fardle-din – n. a long-overdue argument that shakes up a relationship, burning wildly through...

Lukáš Karlovský: I got the green light from management and built Fabric specialization from scratch

By

The post Lukáš Karlovský: I got the green light from management and built Fabric...

Read the latest Blogs

Forums

Which selection criteria is more efficient.

By eichnerm

Is it more efficient to search on an int than a nullable DateTime? I...

Trigger After Update to Update the Updated Table

By Dennis Jensen

Okay I can easily see how to update a table field after an Insert...

The Pervasive Nature of Open Source

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Pervasive Nature of Open...

Visit the forum

Question of the Day

Subqueries II

What is wrong (if anything) with this code?

SELECT *
 FROM Sales.SalesOrderHeader AS soh 
 WHERE customerid IN (SELECT soh.CustomerID 
                       FROM Sales.Customer AS C
   WHERE soh.CurrencyRateID = 1
   ORDER BY c.ModifiedDate)

See possible answers