Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with postgresql
Search options not deleted
user 166808
All versions of PostgreSQL. Add an additional version-specific tag like [postgresql-13] if that context is relevant.
1
vote
Accepted
Postgresql, commas in string_agg function
to escape a ' in a string in postgres, you have to double it
List of escape sequences for Postgresql string data types
so this give you this :
select string_agg(distinct '{name:''' || name || ''',value …
0
votes
How to get column values in where condition in sub query?
For me it's not clear what you want to achieve, maybe you could rephrase your aim in the question. (And maybe I could edit my answer to make the query)
As I unsterdand it, you want to aggregate some …