Morris de Oryx's user avatar
Morris de Oryx's user avatar
Morris de Oryx's user avatar
Morris de Oryx
  • Member for 4 years, 7 months
  • Last seen more than 3 years ago
  • Australia
14 votes

Should I not use camelCase in my column names?

6 votes
Accepted

PostgreSQL naming conventions

2 votes

Why should foreign keys be implemented in my relational database?

2 votes

Create event trigger as non-superuser in Postgres

2 votes
Accepted

Multidimensional pivot in postgres without crosstabs

2 votes

Is it a good or bad idea to use "ON UPDATE CASCADE ON DELETE CASCADE" for foreign keys? Why does this mechanism exist at all?

1 vote

Is there some sort of shortcut/feature in PostgreSQL to avoid horrible storage waste with duplicate values?

1 vote

PostgreSQL NOT IN array slow query

1 vote

Postgresql extremely slow count (with index, simple query)

1 vote

Best Way To Create Time Series from Postgres Table Update History?

1 vote

How to speed up Oracle to PostgreSQL data transfer

1 vote

MADlib apply `cosine_similarity` on term frequency

0 votes

Improving the queries in a view to query custom types

0 votes

PostgreSQL: cast row to type

0 votes

Most efficient way to insert data into archiving table without influencing production?

0 votes

Expression index on a citext column ignored, why?

0 votes

Query for similar syllables on a field

0 votes

Could you monitor all changes made within a postgresql database by somehow subscribing to the replication log?

0 votes

PostgreSQL: Is it possible to get a different function result type (i.e. TABLE) in stored function based on input?