23,213 reputation
13471
bio website
location Vienna, Austria
age 94
visits member for 3 years, 2 months
seen 1 hour ago

1h
comment How can I insert rows into a table from a select query that brings duplicate entries?
@p.matsinopoulos: The query can probably also be simplified (faster) - if you provide the information requested. Plus: are there FK constraints (enforcing relational integrity)? I am trying to keep the number of "unanswered questions" low.
16h
comment Removing all columns with given name
So do you have your answer?
16h
comment How can I insert rows into a table from a select query that brings duplicate entries?
Since nobody stepped forward I'll add an answer. Your query can probably be simplified, too. From which table do you take subject_id? All columns should be table-qualified, so we can understand the query without table definitions.
16h
comment PostgreSQL: Store hierarchial data and return a recursive result with full path data
What exactly is your question?
16h
revised PostgeSQL 9.3: What is the difference between text and pg_catalog.text?
added 4 characters in body
16h
revised PostgreSQL, UPDATE CASE statement uses huge amount of space
edited tags
17h
revised PostgreSQL, UPDATE CASE statement uses huge amount of space
added 926 characters in body
17h
answered PostgreSQL, UPDATE CASE statement uses huge amount of space
17h
answered PostgeSQL 9.3: What is the difference between text and pg_catalog.text?
1d
awarded  Enlightened
1d
awarded  Nice Answer
1d
comment PostgresSQL dynamic execute with argument values in array
@Richard: You may be interested in the added explanation.
1d
revised PostgresSQL dynamic execute with argument values in array
Add detailed explanation - goto answer for references.
2d
comment Reassigning surrogate keys?
@SkippyleGrandGourou: That's called a Foreign Key. Be sure to read the chapter in the manual. And I take it you know about the serial pseudo data type to generate surrogate keys?
2d
answered can I give permission to insert into view, but not to referred table?
2d
revised PostgreSQL CREATE INDEX memory requirement
edited tags
2d
comment UPDATE/DELETE performance on partitioned table
It would seem prudent to provide relevant table definitions.
2d
comment How can I insert rows into a table from a select query that brings duplicate entries?
One of the smart commenters should actually answer. :) Or do you want to close this one as off-topic (too basic)?
2d
revised Reassigning surrogate keys?
edited tags
2d
answered Reassigning surrogate keys?