Linked Questions

Recently I've read Quantified Comparison Predicates – Some of SQL’s Rarest Species: In fact, the SQL standard defines the IN predicate as being just syntax sugar for the = ANY() quantified ...

Using Postgres 9.0, I need a way to test if a value exists in a given array. So far I came up with something like this: select '{1,2,3}'::int[] @> (ARRAY[]::int[] || value_variable::int) But I ...

I've got two postgresql tables: table name column names ----------- ------------------------ login_log ip | etc. ip_location ip | location | hostname | etc. I want to get every IP ...

What is the difference between IN and ANY operator in PostgreSQL? The working mechanism of both seems to be the same. Can anyone explain this with an example?

I'm trying to get rows where a column of type text[] contains a value similar to some user input. What I've thought and done so far is to use the 'ANY' and 'LIKE' operator like this: select * from ...

Here's my function declaration and part of the body: CREATE OR REPLACE FUNCTION access_update() RETURNS void AS $$ DECLARE team_ids bigint[]; BEGIN SELECT INTO team_ids "team_id" FROM "...

I want to pass a query in Django to my PostgreSQL database. When I filter my query using a large array of ids, the query is very slow and goes up to 70s. After looking for an answer I saw this post ...

I have a custom type CREATE TYPE mytype as (id uuid, amount numeric(13,4)); I want to pass it to a function with the following signature: CREATE FUNCTION myschema.myfunction(id uuid, mytypes mytype[...

I'm struggling on what seems to be a ruby semantics issue. I'm writing a method that takes a variable number of params from a form and creates a Postgresql query. def self.search(params) counter ...

I have a JSONB object in PostgreSQL: '{"cars": ["bmw", "mercedes", "pinto"], "user_name": "ed"}' I am trying to use values from the "cars" array inside it in the WHERE clause of a SELECT: SELECT ...

I wrote an API using go and gorm that runs calculations on our database and returns the results. I just hit the parameter limit for an IN condition when using an aggregate. Example query: SELECT SUM(...

I am using Postgres 9.2.24. I have a table named _order with about 100,000,000 rows. The table has a column named merged_id int8. About 2,000,000 of the _order rows have a merged_id value, the rest ...

Following tables: CREATE TEMPORARY TABLE guys ( guy_id integer primary key, guy text ); CREATE TEMPORARY TABLE sales ( log_date date, sales_guys integer[], sales smallint ); INSERT INTO guys VALUES(1,...

I have a type as: CREATE TYPE status_record AS ( id bigint, status boolean ); A procedure that does some processing with an array of type as input parameter as: CREATE OR REPLACE ...

I have found many Questions and Answers about a SELECT excluding rows with a value "NOT IN" a sub-query (such as this). But how to exclude a list of values rather than a sub-query? I want to search ...