12,770 reputation
12049
bio website
location Munich
age
visits member for 3 years, 7 months
seen 6 hours ago

Dec
16
comment How to call a windows program in mysql prompt in windows
I think with "that stands still" you actually mean "that still stands". "That stands still" means "it's not moving"...
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
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
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
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
9
comment MySQL: is there a way to make a self-referencing join recursive?
MySQL does not support recursive queries
Dec
9
comment How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
state = 'idle' does not indicate an open transaction.
Dec
8
comment Slow max, min query in Postgresql View
That's only an explain but not an explain analyze.
Dec
8
comment How do I create a user-defined aggregate function in MySQL (redux)?
Btw: I don't really understand your requirement. There are only two scores for each student in your example data. If you "drop" them, nothing is left to calculate the average
Dec
8
comment How do I create a user-defined aggregate function in MySQL (redux)?
Is upgrading to Postgres an option? You can easily write aggregates in PL/pgSQL there. But for the problem at hand I think you wouldn't even need a custom aggregate. Some clever use of window functions will probably solve this.
Dec
7
comment What is the privilege my user requires to be able to grant CONNECT, RESOURCE and CREATE SESSION to other users in Oracle 11g?
connect and create session is the same thing. There is no need to grant both.
Dec
5
comment How do I connect to oracle apex server through JDBC ?
Cross post: stackoverflow.com/q/27312429/330315
Dec
5
comment How do I connect to oracle apex server through JDBC ?
There is nothing special about an "APEX database". It's just a simple JDBC connection. Any JDBC tutorial will tell you how to do that, e.g. the JDBC tutorial from Oracle: docs.oracle.com/javase/tutorial/jdbc/basics/index.html The Oracle manual for the JDBC driver also explains how to establish a connection: docs.oracle.com/cd/E11882_01/java.112/e16548/… and finally Oracle's FAQ for the JDBC driver also explains this: oracle.com/technetwork/database/enterprise-edition/…
Dec
4
comment postgres function extract from date returns double precision value
@RolandoMySQLDBA: no need to rollback.
Dec
4
comment What is the modern way to partition PostgreSQL across machines, when the data is “naturally partitionable”
And then there is also Postgres-XC: sourceforge.net/projects/postgres-xc
Dec
4
comment postgres function extract from date returns double precision value
@RolandoMySQLDBA: Postgres is a perfectly valid alternative name for PostgreSQL.
Dec
4
comment Return total number of rows and selected (aggregated) data
You can add a column containing the total count using: count(*) over () as total_count (but that will be repeated for each row)