Thursday , September 28 2023

PostgreSQL Any Operator

In today’s article, we will be cover the use of the Any operator, which has the same meaning as some in PostgreSQL.

One of the results from nested queries works.

General usage is as follows.

Let’s have a table with student names and let this table be named as student_all, with its number, name, and surname, and the other table with no, vize, final grades named student_vf, and using these two tables, let’s find the students with a vize grade of 38.

We will use the ANY command to do this.

In the plpgsql sentence above, in our first outer query, we want all the columns in the main table to come and we use the common name of the two tables in the WHERE condition to use our subquery.

Then after the ANY command is written, we open parenthesis and we specify the condition in the subquery because we say bring those with 38 visas.

We used ” > ” for Any but it has more than one parameter.

These are as follows;

=ANY: Represents the result or records equal to any of the results obtained from the subquery.

>ANY: Refers to the result obtained from the subquery or records greater than any of the results.

>=ANY: It refers to records greater than or equal to any of the subquery’s results.

<ANY: Refers to records less than any of the results from the subquery.

<=ANY: Indicates records less than or equal to any of the results obtained from the subquery.

!=ANY or <> ANY: This command is generally useless because it means different from at least one of the returned records, which means fetching all records, so we can say that it means the same as SELECT * FROM.


About Faruk Erdem

Leave a Reply

Your email address will not be published. Required fields are marked *