Profile Activity

mountainclimber

Meta user

Network profile

Reputation

629

Top tag

postgresql

Next privilege

1,000 Rep.

See votes, expandable usercard

Badges

Newest

Yearling

Next badge

15/30

Impact

0 posts edited

0 helpful flags

51 votes cast

Summary Answers Questions Tags Badges Favorites Bounties Reputation All actions

21 Questions

Views Newest Activity Votes

votes

answers

views

Is pg_trigger_depth() bad to use for preventing trigger cascading (recursion)?

postgresql trigger

Feb 3 '17 at 21:02 Community♦ 1

votes

answers

173

views

Speed up query calculation. Where can I add indexes or optimize the query or server?

postgresql postgresql-9.3 postgresql-performance

Mar 3 '17 at 15:22 Community♦ 1

votes

answers

views

Schema for Financial Database

database-design schema data-warehouse timestamp

Aug 31 '16 at 17:09 Artemy Prototyping 55

votes

answer

views

Setting connection properties (application_name) for Postgres connections

postgresql connectivity

Sep 1 '17 at 13:47 dezso 24.4k

votes

answer

948

views

speed up PostgreSQL calculations via OLAP warehouse?

postgresql query-performance schema data-warehouse olap

Aug 24 at 6:03 Community♦ 1

votes

answer

views

Generic end date of quarter, PostgreSQL

postgresql functions date interval

Jan 31 at 12:22 Community♦ 1

votes

answers

358

views

Within a trigger is there a way to tell if an update or insert came from a trigger or not?

postgresql trigger

May 30 '18 at 6:21 Ziggy Crueltyfree Zeitgeister 4,343

votes

answers

228

views

Calculations using two tables with different date frequencies

postgresql timestamp

Feb 10 '17 at 17:49 Community♦ 1

votes

answer

102

views

PostgreSQL: translating user-defined calculations into executable calculation in trigger

postgresql data-warehouse psql mdx

Jan 31 '17 at 20:24 Community♦ 1

votes

answer

375

views

Best way to move CTE into query so planner can better optimize and I can add indexes speed it up? [closed]

postgresql optimization subquery postgresql-performance cte

Sep 15 at 15:02 Community♦ 1

votes

answer

views

Percentile rank that takes sorted argument (or same functionality) in PostgreSQL 9.3.5

postgresql postgresql-9.3 aggregate rank

Feb 16 '17 at 22:07 Erwin Brandstetter 108k

votes

answers

591

views

PostgreSQL: trigger to autopopulate other fields with sub-strings of other field inserted

postgresql trigger psql

Jan 30 '17 at 23:54 Evan Carroll 41.4k

vote

answers

views

Making intermediate CTE results available for output/query without reprocessing earlier CTEs

postgresql cte

Aug 30 '17 at 17:47 mountainclimber 629

vote

answer

views

Remove first all null records from first part of time series until one value is not null and return the rest, in PostgreSQL

postgresql

Aug 25 '17 at 21:07 indiri 2,081

vote

answers

219

views

PostgreSQL: windowing to replace multiple sub-queries … hopefully

postgresql subquery

Feb 1 '17 at 21:33 Evan Carroll 41.4k

vote

answer

views

PostgreSQL / pgAdminIII: is it possible to send command line commands via the UI

postgresql pgadmin psql

Dec 15 '16 at 3:26 Community♦ 1

votes

answers

views

substitute a value in one record with a value in another record based on a value comparison across the records

sql-server

Aug 30 at 17:22 mountainclimber 629

votes

answer

202

views

Is there Hypothetical-Set Aggregate Function equivalent to `ntile` in Postgres?

postgresql aggregate

Jun 30 '17 at 9:30 dnoeth 3,766

votes

answer

views

foreign key violation within trigger on insert of 'new' id in other table as foreign key

postgresql trigger

Feb 16 '17 at 20:17 joanolo 10.7k

votes

answers

773

views

How to prevent UPDATE on any record in a table, but allow INSERT and DELETE (PostgreSQL)?

postgresql update

Oct 20 '16 at 22:01 mountainclimber 629

-1

votes

answer

views

Proper use of array in table? Multiple elements of the same field and record

postgresql database-design schema table

Sep 21 '16 at 14:46 Marco 3,750

Stack Exchange Network

current community

your communities

more stack exchange communities

Next privilege

Next badge

21 Questions

Is pg_trigger_depth() bad to use for preventing trigger cascading (recursion)?

Speed up query calculation. Where can I add indexes or optimize the query or server?

Schema for Financial Database

Setting connection properties (application_name) for Postgres connections

speed up PostgreSQL calculations via OLAP warehouse?

Generic end date of quarter, PostgreSQL

Within a trigger is there a way to tell if an update or insert came from a trigger or not?

Calculations using two tables with different date frequencies

PostgreSQL: translating user-defined calculations into executable calculation in trigger

Best way to move CTE into query so planner can better optimize and I can add indexes speed it up? [closed]

Percentile rank that takes sorted argument (or same functionality) in PostgreSQL 9.3.5

PostgreSQL: trigger to autopopulate other fields with sub-strings of other field inserted

Making intermediate CTE results available for output/query without reprocessing earlier CTEs

Remove first all null records from first part of time series until one value is not null and return the rest, in PostgreSQL

PostgreSQL: windowing to replace multiple sub-queries … hopefully

PostgreSQL / pgAdminIII: is it possible to send command line commands via the UI

substitute a value in one record with a value in another record based on a value comparison across the records

Is there Hypothetical-Set Aggregate Function equivalent to `ntile` in Postgres?

foreign key violation within trigger on insert of 'new' id in other table as foreign key

How to prevent UPDATE on any record in a table, but allow INSERT and DELETE (PostgreSQL)?

Proper use of array in table? Multiple elements of the same field and record