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

Jan
20
comment Logical or in oracle PL/SQL
A logical OR on bit level is equivalent to adding the two numbers: error1 + error2. But why don't you use a real boolean?
Jan
19
comment What is the best way to store a lot of user-encrypted data?
I do. You don't have to use those things if you don't need them. But if you do have requirements that can't easily be solved using a relational DBMS you don't need to introduce another piece of software which just adds complexity to the whole system.
Jan
19
comment What is the best way to store a lot of user-encrypted data?
Plus: relational DBMS (especially Postgres) have been adding more and more "NoSQL features" (key/value storage, JSON, XML, arrays, ...)
Jan
19
comment Postgres FATAL: could not open relation mapping file
If the datadir exists, then it's probably a file permission problem. The user running the postgres service probably does not have the rights to access the files (or is looking in the wrong place)
Jan
19
comment Postgres FATAL: could not open relation mapping file
Did you run initdb?
Jan
17
comment Changes in Oracle Database implicit conversion rules for select statement
I'm almost 100% certain that 10g would have thrown the same error. So I don't think it's an upgrade issue. Maybe somewhere during the migration someone entered some testdata that broke that query.
Jan
17
comment Changes in Oracle Database implicit conversion rules for select statement
If the column held only numbers, the exception wouldn't have happened in the first place. So I doubt it can be converted.
Jan
17
comment MySQL/MariaDB stored procedure inserts even with syntax error
"but it's a theoretically legitimate operation". No it's not. In SQL INSERT INTO ambiguity (c1) VALUES (c1) is an invalid statement because of the column reference in the values clause. The values clause is only allowed to contain value literals, expressions or scalar queries but not column references. Additionally the only possible value for that column would be NULL there (because it's undefined) and thus your example insert should at least fail with an not-null constraint violation.
Jan
17
comment How to copy PostgresSQL database from remote server to LOCAL PC WITHOUT PG_DUMP(ALL)?
Then you are probably connecting with a different user in pg_dump than you use in your gui or the commandline.
Jan
16
comment Which SQL Server product does version 622 represent?
Seems to be some intermediate version number: social.msdn.microsoft.com/Forums/en-US/…
Jan
16
comment Postgres CREATE DATABASE already has data and tables
The problem is not that he/she can not create the database - the database is created. The problem is that the (newly) created database contains stuff that shouldn't be in there.
Jan
16
comment How to copy PostgresSQL database from remote server to LOCAL PC WITHOUT PG_DUMP(ALL)?
pg_dump is a client application. You can install it on any computer from which you have access to the database server. You ca download the Postgres ZIP archive, unzip it and run pg_dump without any further "installation" (works on Windows just as well as on Linux)
Jan
16
comment How to copy PostgresSQL database from remote server to LOCAL PC WITHOUT PG_DUMP(ALL)?
pg_dump neither needs superuser nor root access to work. All you need is a regular login.
Jan
16
comment Alternative to TEMPORARY tables capable of re-opening in a query?
Yes of course it does - although you usually don't need temp tables in Postgres. Complex queries are handled quite good and the overhead of reading data twice (once to write it into the temp table, the second time to read it from there) is usually not needed anyway.
Jan
15
comment Can I provide a default for a left outer join?
Please use ANSI SQL when the question is only tagged with sql (which means "SQL the query language". That tag does not denote any specific DBMS product or dialect). The part: [b2]=CASE WHEN ... END is an invalid (standard) SQL expression.
Jan
15
comment Alternative to TEMPORARY tables capable of re-opening in a query?
You can always upgrade to Postgres ;)
Jan
15
comment Postgres 9.2 - Create View Different Column Names
@dezso: I personally prefer to (re)name them in the select itself. That way I can immediately see which "source column" maps to which view column. If you have a complicated query it's not always easy to spot which name the query column has in the view.
Jan
15
comment Postgres 9.2 - Create View Different Column Names
@josh1234: why not simply rename the column then? Would probably save you a lot of trouble in the long run. Could even be automated probably.
Jan
15
comment how does multiple column index work in details
All you ever wanted to know about indexes: use-the-index-luke.com
Jan
14
comment Will the indexing affect insert/update/delete operation in Mysql
An index will slow down inserts. It can slow down updates and deletes. It can speed up selects, updates and deletes (and inserts based on selects).