user avatar
user avatar
user avatar
timpone
  • Member for 10 years, 2 months
  • Last seen more than a month ago
9 votes
1 answer
8k views

How to get 0 as array_length() result when there are no elements

7 votes
1 answer
3k views

Group and count array elements using intarray

6 votes
1 answer
3k views

Order result by count of common array elements

6 votes
2 answers
17k views

possible to query a database for an empty jsonb

5 votes
1 answer
106 views

Select a count with some conditions

3 votes
1 answer
1k views

possible to reference a jsonb_array_length in a where clause

2 votes
2 answers
9k views

PostgreSQL array column, querying and grouping by array field

2 votes
1 answer
2k views

how to create invalid utf-8 characters in MySQL

2 votes
3 answers
676 views

getting MySQL error 1064 but very (absurdly) simple query in MySQLWorkbench

1 vote
1 answer
47 views

how to do a count on a grouped by value in Postgres 9.4

1 vote
2 answers
180 views

would it be possible in postgres to get a count of sql hits on a select statement

1 vote
1 answer
25 views

multiple groupings in select clause in postgres

1 vote
0 answers
623 views

postgres query taking very long and not sure why

1 vote
3 answers
91 views

How to add a summary count to this query

0 votes
1 answer
952 views

how to search this field in Postgres for an array of characters

0 votes
1 answer
69 views

select users who do something on each date in sql server

0 votes
1 answer
14 views

aggregating sums for specific time but would like to have multiple times in the same query

0 votes
2 answers
1k views

Query that was working on MySQL is not working on PostgreSQL

-1 votes
1 answer
76 views

in postgres how to select items that have a dupe across two columns

-1 votes
1 answer
25 views

in Postgres 9.5, can you select a set of users and have a subset be ordered first?