4,026 reputation
11123
bio website sqlblog.com/blogs/…
location Chicago, IL
age
visits member for 2 years, 4 months
seen 4 hours ago

Developer


Feb
5
revised Hierarchical structure with limited number of records per user
added 856 characters in body
Feb
1
revised How to design database for polymorphic relationships
edited tags
Jan
28
revised Storing and querying rolling data in PostgreSQL
edited tags
Dec
31
revised Does this query always correctly retrieve the types of array parameters
added AND parameter_mode = 'IN'
Dec
31
revised Does this query always correctly retrieve the types of array parameters
added an alias, so that the first select works
Dec
16
revised Query planner thinks doing a sequential scan on a very large table is faster than using an index?
edited title
Dec
6
revised Database design
edited tags
Dec
4
revised PosgtreSQL - Change multiple fields collation in one query
fixed typo in title
Nov
9
revised Are there other ways to select a dynamic list of columns?
added 252 characters in body
Oct
16
revised PostgreSQL 9.2 tstzrange null/infinity CONSTRAINT CHECK
edited tags
Oct
9
revised Two possibilities of primary key
edited tags
Sep
9
revised Constrains relationship
edited tags
Sep
8
revised Constraint to one of the primary keys as foreign key
edited tags
Jun
26
revised How to find parent rows that have indentical sets of child rows?
edited tags
Jun
5
revised Relational database primary key requirements
edited tags
Jun
4
revised Can I add a unique constraint that ignores existing violations?
edited tags
Apr
5
revised Gaps and islands: client solution vs T-SQL query
added 78 characters in body
Apr
4
revised Gaps and islands: client solution vs T-SQL query
added 146 characters in body
Apr
4
revised Gaps and islands: client solution vs T-SQL query
added 132 characters in body
Apr
4
revised Gaps and islands: client solution vs T-SQL query
added 13 characters in body