Skip to main content
Database Administrators
LondonRob's user avatar
LondonRob's user avatar
LondonRob's user avatar
LondonRob
  • Member for 5 years, 1 month
  • Last seen more than a month ago
Profile Activity
Stats
233
reputation
5k
reached
0
answers
6
questions
Communities
View all
About

I do data engineering and other heavy back-end stuff for a renewable energy company in the UK.

Ask me anything about:

  • Postgres
  • Python
  • SQL
Badges
This user doesn’t have any gold badges yet.
1
silver badge
8
bronze badges
Top tags
View all tags
0
Score
6
Posts
100
Posts %
0
Score
2
Posts
33
Posts %
0
Score
1
Posts
17
Posts %
0
Score
1
Posts
17
Posts %
0
Score
1
Posts
17
Posts %
0
Score
1
Posts
17
Posts %
Top posts
question
5
Why does COALESCE prevent the use of an index on a varchar, but not on a text column?
Aug 2, 2021
question
4
Why does BETWEEN use a btree index but "element is contained by" range operator (<@) does not? [duplicate]
Feb 16, 2021
question
2
Prevent consecutive duplicate values without a trigger
Sep 3, 2020
question
1
Why can a partition bound expression not include a casting operation?
May 20, 2021
question
0
Why is an unindexed range operator (<@) faster than using BETWEEN with an index?
Feb 22, 2021
question
0
ON CONFLICT with index column name is a syntax error
Oct 4, 2022
Top network posts
View all network posts
3677
Delete a column from a Pandas DataFrame
889
How to filter Pandas dataframe using 'in' and 'not in' like in SQL
308
What is withRouter for in react-router-dom?
280
Getting individual colors from a color map in matplotlib
204
Pandas get topmost n records within each group