All Questions
Tagged with string-splitting postgresql
4 questions
5
votes
1
answer
203
views
Match .csv values as INTs. If one value from a group in the .csv matches one in another group, then merge strings
Here we have two sets of numbers. The problem is that I can't figure out how to get from the input to the output of numbers (DDL and DML below and also in the fiddle here).
current_data
1,2,3
1,4
1,5,...
- 67
6
votes
1
answer
17k
views
Split a comma-separated record into its own rows
I have the following table, named stores:
store_id INT
emails VARCHAR
That contains values:
store_id
emails
1
[email protected],[email protected]
2
[email protected],[email protected]
4
admin@...
0
votes
1
answer
2k
views
Index for split string. PostgreSQL 10
I have the following string in db:
A/B/C/
A/B/D/
E/F/C/
It's the uri column.
The table is the following:
create table meta_info (
id bigserial primary key,
uri varchar,
created ...
- 115
0
votes
1
answer
1k
views
Querying an array of strings with a string that represents search terms
I have an array of values like:
array ('hello world', 'foo', 'bar') -- terms here have only letters and one space at most
and some text like: 'foo hello-world hello1world'
and I would like to get ...
- 1,203