12,790 reputation
12049
bio website
location Munich
age
visits member for 3 years, 7 months
seen 1 hour ago

Dec
16
comment Unique index on columns which are allowed to be NULL
See here for example: dba.stackexchange.com/q/75034/1822
Dec
16
comment Unique index on columns which are allowed to be NULL
What is the goal of that index? Only having a single offer per product? Then you don't need to include the price columns at all. Unless you can have different prices for the same product for the same period (which I doubt). You probably want an exclusion constraint on valid_from, valid_to for the same product_id
Dec
16
answered Group by range of years
Dec
15
revised Enterprise Manager cannot connect to 11g database instance
edited body; edited tags; edited title
Dec
15
revised Prepared statement overhead
edited tags
Dec
13
revised Which keyword i should use?
added 121 characters in body
Dec
13
comment Which keyword i should use?
@miracle173: you are right. The join assumes that (a,c) is unique. Thanks for pointing that out.
Dec
13
comment Which keyword i should use?
My first example creates a table with only two columns because the select list only has two columns.
Dec
13
answered Which keyword i should use?
Dec
13
revised Which keyword i should use?
added 2 characters in body
Dec
13
comment Change execution plan in Oracle
Edit your question and add the query, the index definitions, the tables (as create table) and the execution plan. All as formatted text please.
Dec
13
answered How can I determine if a table exists in the current search_path with PLPGSQL?
Dec
12
reviewed Approve Rollback in Oracle
Dec
11
revised Add function parameter to SQL query WHERE clause
added 30 characters in body
Dec
11
comment Translate psql meta-command to SQL
Start psql with the -E parameter . The manual will give you more details: postgresql.org/docs/current/static/app-psql.html
Dec
11
comment PostGIS 1.5 Error with PostgreSQL 8.4
Is there any reason you are using an outdated Postgres version?
Dec
11
revised hide system databases sql server management studio
edited tags
Dec
9
comment MySQL: is there a way to make a self-referencing join recursive?
MySQL does not support recursive queries
Dec
9
revised Querying really slow Postgres
Its's Postgres not PostGres
Dec
9
comment How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
state = 'idle' does not indicate an open transaction.