Casting data types in Postgresql Data conversion is common in all programing paradigms especially when handling transactions in the databases. Like in other databases postgresql database provides for CAST operations which enable conversion of one data type into another. There are various cast operations in postgresql for converting string to integers, casting to Boolean, casting … Continued

Introduction IT pros have been comparing PostgreSQL and MySQL for over a decade, and with good reason. While MySQL has been a force to be reckoned with for some time, PostgreSQL is seen as the better administrative tool for a number of reasons. While MySQL remains popular mainly due to it being included with all … Continued

What is SQL Cross Join? How to use Cross Join? In the last few articles, we discussed a lot about joins in SQL. Today, we are going to talk about “cross join”, another type of join in SQL. What is CARTESIAN JOIN or CROSS JOIN in SQL? With a Cross Join, you will see all possible conditions … Continued

Introduction PostgreSQL is an open-source relational database management system, or RDBMS, designed to handle a wide range of tasks from individual computers to mega data warehouses. Also known as Postgres, PostgreSQL is used as the default database for MacOS, Linux and Windows, among others. PostgreSQL open source has been around for over 20 years, but … Continued

What is Full Outer Join In SQL? How to use Full Outer Join in SQL? In the last few tutorials, we have discussed Inner Join, Left Join, and Right Join SQL. Today, we are going to discuss the Full Outer Join. What is Full Outer Join? In the Full Outer Join or Full Join, it produces combined … Continued

What is Right Outer Join? How to Use Right Outer Join? In the previous tutorials, we have talked about Inner Join and left outer join. Today I am going to explain the right outer join. What is Right Outer Join? Right outer is just the opposite of the left outer join. In the Right Outer join, all … Continued

Introduction In this article we will discuss the UNION and UNION ALL operators in PostgreSQL database. These two operators are both used combine results from different tables. It’s rare that you’ll develop an application without ever having to create queries that combine result sets from multiple tables. Unions come from set theory. In set theory … Continued

What is Left Outer Join in SQL? Today, we will discuss the Left Outer Join. Left Outer Join or Left Join is the same thing in SQL. In the left outer join, it returns all the data from the left table of the join. At the same point of time, it also matches the data from … Continued

Introduction When you create a table in a PostgreSQL database, you need to specify a data type for each column in that table. The data type is a critical piece of information– it defines what kind of data can be stored in a given column. For example, if you have a column with an integer … Continued

What is SQL Inner Join? Inner joins in SQL is one of the easiest joins that can be used by any SQL Developer. You can also call it as join or Equi Join. In SQL, joins work with two or more tables to get data from both tables with the help of a common field. … Continued