12,144 reputation
11947
bio website
location Munich
age
visits member for 3 years, 5 months
seen 2 hours ago

2h
comment numbering distinct column values in an ordering but not just displaying the total
There is no DBMS named "Visual 8.0"
17h
comment numbering distinct column values in an ordering but not just displaying the total
Which DBMS are you using? Postgres? Oracle?
18h
comment Optimizing query - understanding explain
The explain analyze says your query only takes 131 milli seconds (= 0.131 seconds), not 1.5 seconds.
22h
comment Insert any type of text in a column
@aasim.abdullah: that's not the question. This refers to Postgres' "dollar quoting"
22h
answered Insert any type of text in a column
1d
revised Delete and merge duplicate records from joined tables?
edited tags
1d
comment 2 Date Ranges - How many days from one range excluding weekends overlap
Which DBMS are you using? Postgres? Oracle?
1d
revised 2 Date Ranges - How many days from one range excluding weekends overlap
added 8 characters in body
1d
comment Where to download (Dutch) Postgresql Fulltext Search dictionaries
I tried those from the OpenOffice project and the German one works without problems, but the AFFIX File for dutch seems to have problems (I get an error: "wrong affix file format for flag" when trying to use it)
1d
comment ACID violation in Postgres 9.1?
That statement is only true if you use the "serializable" isolation level.
1d
comment ACID violation in Postgres 9.1?
Your understanding of ACID is wrong. It is not violated here. One transaction will never, ever, under no circumstances see uncommitted data from another session. And therefor the select statement will never see new rows that are inserted concurrently.
1d
comment Where to download (Dutch) Postgresql Fulltext Search dictionaries
I used the German dictionary from OpenOffice a while ago and that worked without problems. Maybe LibreOffice changed something in their dictionaries.
1d
comment ACID violation in Postgres 9.1?
If you run them at the same time, the will not see the effects of the other insert. If you run them one after the other with autocommit turned off, you basically get the same behaviour: Run the first insert, don't commit, run the select of that insert from a second session and you'll see. As long as the insert has not been committed no other session is allowed to see those values, hence the other sessions retrieves the same information as the first session. This is how transactions work: postgresql.org/docs/current/static/tutorial-transactions.html
1d
comment modify a select stmt to give you the definition of a column value
Which DBMS are you using?
1d
comment ACID violation in Postgres 9.1?
I don't see why what ACID property would prevent concurrent statements to return the same fid. The fid is "generated" using the select statement, and the select statement will return whatever is visible to the current session. Two concurrent selects will simply return the same fids because they don't see the uncommitted inserts from the "other" session. Using a select statement to generate "new" ids is always a bad choice. Your statement is just a select max(..) in disguise which will never work properly precisely because of the ACID characteristics.
1d
revised How do I select all child table records based on condition
edited tags
2d
revised The client need 'SUPER' privileges to the reports DB in order to create and maintain my Functions
rolled back to a previous revision
2d
reviewed Reject suggested edit on The client need 'SUPER' privileges to the reports DB in order to create and maintain my Functions
2d
comment CLOB data type is not working as expected
Well, the error message is pretty clear. Isn't it? You can't have a string literal longer than 4000 bytes. You need to use statement parameters. 12c can be configured to allow for longer string literals. See e.g. here: dbaglobe.com/2013/11/oracle-12c-new-features-varchar2.html But then you might hit that error just a little bit later.
2d
revised Is there anyway to search PL/SQL reserved words with contains function?
added 66 characters in body; edited tags