18,853 reputation
12658
bio website
location Vienna, Austria
age 94
visits member for 2 years, 9 months
seen 4 hours ago

5h
revised Is there a name for this database structure?
add json types
6h
comment Prevent postgres function of running more than 1 instance at the same time
Thanks for the flock command. Very handy. I guess it should be built into the function, though, to cover all vectors.
15h
revised Force drop db while others may be connected in postgresql
format code
18h
comment Lookup table for a one-to-many relationship
CLUSTER in Postgres does not do the same as a clustered index in SQL server. Not sure what this is supposed to achieve.
2d
revised Primary key with randomly varying increments (so it cannot be guessed easily)
fitting title, format, typos, add tag
2d
revised Mixed search in multiple columns
edited tags
2d
comment How to inner join some tables and outer join others?
@Bryce: Most questions seem easy once the answer is known. You presented your question very well.
2d
revised How to inner join some tables and outer join others?
explain full join vs. right join
Jul
21
revised How to inner join some tables and outer join others?
added 112 characters in body
Jul
21
revised How to inner join some tables and outer join others?
add tag, trim noise, minor edits
Jul
21
answered How to inner join some tables and outer join others?
Jul
20
comment Very large btree index with few rows (openstreetmap gis data)
@a_horse_with_no_name: You still may have to include the condition explicitly, for instance in a prepared statement or function where the parameter can be NULL. The explicit condition would allow Postgres to use the index.
Jul
20
revised Very large btree index with few rows (openstreetmap gis data)
clarify detail
Jul
19
revised Very large btree index with few rows (openstreetmap gis data)
add links
Jul
19
answered Very large btree index with few rows (openstreetmap gis data)
Jul
19
answered Mixed search in multiple columns
Jul
17
revised Primary key with randomly varying increments (so it cannot be guessed easily)
added 6 characters in body
Jul
17
revised Primary key with randomly varying increments (so it cannot be guessed easily)
added 51 characters in body
Jul
17
answered Primary key with randomly varying increments (so it cannot be guessed easily)
Jul
16
revised Postgres 9.3 changes the standard_conforming_strings value
typos