13,175 reputation
12151
bio website
location Munich, Bavaria
age
visits member for 3 years, 8 months
seen 3 hours ago

Jan
24
comment Take advantage of monotonic columns in PostreSQL
"Adding a multicolumn index is useless" - are you sure? Did you test it?
Jan
23
revised Difficulty with nested query order & grouping
added 38 characters in body; edited tags
Jan
23
revised Timeline or time function in PostgreSQL
remove link to unsupported version
Jan
23
comment PostgreSQL operator uses index but underlying function does not
Do you have to use a PreparedStatement? As long as you don't use that, you can use a ? without any problems.
Jan
23
comment Timeline or time function in PostgreSQL
What exactly is "messy" about that output? To me this looks exactly the way you want it.
Jan
22
revised Oracle Package in Data Dictionary that can't be dropped
added 76 characters in body
Jan
22
revised Improving lots of Left Joins ( SQL Server 2008 - procedure )
edited tags
Jan
22
comment How to store thousands of properties related to a record in PostgreSQL?
I think the only option you have is to actually create a sample database with a hstore column and see how this performs.
Jan
22
comment what is the difference between data file and data block in oracle
I think this link to the manual is better: docs.oracle.com/database/121/CNCPT/logical.htm#CNCPT004
Jan
22
comment Access Oracle GTT table data from another session?
"I know GTT tables data is only session specific vs. "is their any way to access/read GTT table that belongs to another session" if you know it's impossible then why do you ask?
Jan
22
revised sql agent job hangs without any errors or warnings
edited tags
Jan
22
comment Getting around the constraint “column must appear in the GROUP BY clause or be used in an aggregate function”
You state that "one person can only have one license" so why is person_id not a primary key in the license table then?
Jan
22
comment Getting around the constraint “column must appear in the GROUP BY clause or be used in an aggregate function”
If the license table had a primary key (why doesn't it have one?), you can use group by person.id, license.id because the ungrouped columns are then functionally dependent on the two primary keys.
Jan
22
comment what is the difference between data file and data block in oracle
A data file contains many, many data blocks
Jan
22
revised How to select the first row of each group?
edited tags
Jan
21
comment PostgreSQL and array of custom type
Here is an example: sqlfiddle.com/#!15/5c776/4
Jan
21
comment PostgreSQL and array of custom type
It seems you'd better use a JSON column directly or store the contactinfo in a hstore column. An array like that will be quite hard to handle. The hstore column will be much more flexible when you need to remove or add elements.
Jan
21
revised Recover data in a SQL Server table without backups
The database product is called SQL Server, not SQL
Jan
21
revised Not receiving archivelogs from production to remote side
edited tags
Jan
21
comment Error when creating Trigger (PostgreSQL 9.4)
'company_t' is a string literal, not an identifier. Identifiers are either not quoted at all (which I highly recommend to do!) or quoted using double quotes " (as you have did in the create table statement - which I would discourage you from doing). More details on identifiers are in the manual: postgresql.org/docs/current/static/…