select * from tbl TABLESAMPLE system (5)
The SYSTEM method is significantly faster than the BERNOULLI method when small sampling percentages are specified, but it may return a less-random sample of the table as a result of clustering effects.
Das Elterngeld-Netto wird berechnet, indem vom bereinigten Gesamtbrutto die Steuern und Sozialabgaben abgezogen werden. Die Steuerberechnung erfolgt dabei anhand eines modifizierten Programmablaufplans für die Ermittlung der Lohnsteuer. Für die Sozialabgaben hat der Gesetzgeber die Abzüge direkt in das Elterngeldgesetz aufgenommen. Sie betragen zusammen 21 Prozent des SV-Bruttos.
WHERE some_col > ''
Since null > '' produces unknown, this has the effect of filtering out both null and empty strings.
@JoshPinter: coalesce(some_col, '') = ''
Extract the PKCS#7 object:
$ openssl smime -verify -in file.msg -noverify -pk7out > file.pk7
Dump the certificates in that file
openssl pkcs7 -print_certs -in file.pk7 > file.pem
Open the file in your favorite text editor and seperate out each certificate individually in to it's own file and import:
For each CA certificate that you want to trust:
smime_keys add_root file.pem
Note: You do not need to trust all intermediate CAs. You can simply trust the end-user certificate.
For the subject certificate that you want to add:
smime_keys add_cert file.pem
SELECT * FROM pg_stat_activity WHERE state = 'active';
So you can identify the PID of the hanging query you want to terminate, run this:
SELECT pg_cancel_backend(PID);
For bureaucratic reasons, a colleague of mine had to print, sign, scan and send by email a high number of pages. To save trees, ink, time, and to stick it...
Switching the stream from parallel() to sequential() worked in the initial Stream API design, but caused many problems and finally the implementation was changed, so it just turns the parallel flag on and off for the whole pipeline. The current documentation is indeed vague, but it was improved in Java-9:
The stream pipeline is executed sequentially or in parallel depending on the mode of the stream on which the terminal operation is invoked. The sequential or parallel mode of a stream can be determined with the BaseStream.isParallel() method, and the stream's mode can be modified with the BaseStream.sequential() and BaseStream.parallel() operations. The most recent sequential or parallel mode setting applies to the execution of the entire stream pipeline.
-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query
FROM pg_stat_activity
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'
ORDER BY query_start desc;
REQUEST: Only when the request comes directly from the client
FORWARD: Only when the request has been forwarded to a component (see Transferring Control to Another Web Component)
INCLUDE: Only when the request is being processed by a component that has been included (see Including Other Resources in the Response)
ERROR: Only when the request is being processed with the error page mechanism (see Handling Servlet Errors)
You can direct the filter to be applied to any combination of the preceding situations by selecting multiple dispatcher types. If no types are specified, the default option is REQUEST.
sudo apt-get install libemail-outlook-message-perl libemail-sender-perl
from a command line. Use
msgconvert *.msg
to convert every file in a directory at once. MSGConvert will produce copies of your .msg-files with the suffix .msg.eml
Partial Indexes
A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate of the partial index). The index contains entries for only those table rows that satisfy the predicate.
CREATE INDEX access_log_client_ip_ix ON access_log (client_ip)
WHERE NOT (client_ip > inet '192.168.100.0' AND client_ip < inet '192.168.100.255');
def sample = ['Groovy', 'Gradle', 'Grails', 'Spock'] as String[]
def result = sample.stream() // Use stream() on array objects
.filter { s -> s.startsWith('Gr') }
.map { s -> s.toUpperCase() }
.toList() // toList() added to Stream by Groovy
public class User implements Serializable {
//class attributes, constructors, setters and getters as shown above
/**
* Always treat de-serialization as a full-blown constructor, by validating the final state of the de-serialized object.
*/
private void readObject(ObjectInputStream aInputStream) throws ClassNotFoundException, IOException
{
// perform the default de-serialization first
aInputStream.defaultReadObject();
// make defensive copy of the mutable Date field
dateOpened = new Date(dateOpened.getTime());
// ensure that object state has not been corrupted or tampered with malicious code
//validateUserInfo();
}
/**
* This is the default implementation of writeObject. Customize as necessary.
*/
private void writeObject(ObjectOutputStream aOutputStream) throws IOException {
//ensure that object is in desired state. Possibly run any business rules if applicable.
//checkUserInfo();
// perform the default serialization for all non-transient, non-static fields
aOutputStream.defaultWriteObject();
}
}
The “vanilla” store implementation you get by calling createStore only supports plain object actions and hands them immediately to the reducer.
However, if you wrap createStore with applyMiddleware, the middleware can interpret actions differently, and provide support for dispatching async actions. Async actions are usually asynchronous primitives like Promises, Observables, or thunks.
(?=foo) Lookahead Asserts that what immediately follows the current position in the string is foo
(?<=foo) Lookbehind Asserts that what immediately precedes the current position in the string is foo
(?!foo) Negative Lookahead Asserts that what immediately follows the current position in the string is not foo
(?<!foo) Negative Lookbehind Asserts that what immediately precedes the current position in the string is not foo
git revert -m 1 <merge-commit>
With ‘-m 1’ we tell git to revert to the first parent of the mergecommit on the master branch. -m 2 would specify to revert to the first parent on the develop branch where the merge came from initially
(lieber vorher prüfen welcher branch welcher ist)
git merge -s ours branch1
The Ours strategy operates on multiple N number of branches. The output merge result is always that of the current branch HEAD. The "ours" term implies the preference effectively ignoring all changes from all other branches. It is intended to be used to combine history of similar feature branches.
when the application hasn’t used lambda expressions before, even the framework for generating the lambda classes has to be loaded (Oracle’s current implementation uses ASM under the hood). This is the actual cause of the slowdown, loading and initialization of a dozen internally used classes, not the lambda expression itself.
The following example connects user scott with password tiger to a database with SID orcl through port 1521 of host myhost, using the Thin driver.
Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@myhost:1521:orcl", "scott", "tiger")
Set gfx.color_management.mode to 1 to enable colormanagement. The parameter changes to bold text which indicates that it is now user-defined.
Below are all parameters which can be altered:
gfx.color_management.display_profile
The Full Path to you monitor’s color profile. For example: C:\colorprofiles\HP Z27x\HP Z27x sRGB D65 ICC Profile.icm
gfx.color_management.enablev4
Set to true (doubleclick the entry) to enable colormanagement v4 (Recommended).
gfx.color_management.mode
0 – Disable color management.
1 – Enable color management for all rendered graphics. (Recommended)
2 – Enable color management only for tagged images only. (Default)
gfx.color_management.rendering_intent
-1 Honor the rendering intent specified in the image file.
0 Perceptual (Default) (Recomended)
1 Relative colorimetric
2 Saturation
3 Absolute colorimetric
To finaly enable color management you have to restart firefox.
In OpenAPI version 3, you do this with the allOf keyword:
components:
schemas:
BasicErrorModel:
type: object
required:
- message
- code
properties:
message:
type: string
code:
type: integer
minimum: 100
maximum: 600
ExtendedErrorModel:
allOf: # Combines the BasicErrorModel and the inline model
- $ref: '#/components/schemas/BasicErrorModel'
- type: object
required:
- rootCause
properties:
rootCause:
type: string
In the example above, the ExtendedErrorModel schema includes its own properties and properties inherited from BasicErrorModel
entr (http://entrproject.org/) provides a more friendly interface to inotify (and also supports *BSD & Mac OS X).
It makes it very easy to specify multiple files to watch (limited only by ulimit -n), takes the hassle out of dealing with files being replaced, and requires less bash syntax:
$ find . -name '*.py' | entr ./myfile.py
You can force Git to detect the history of the copied file:
Instead of copying, switch to a new branch and move the file to its new location there.
Switch to the original branch and rename the file.
Merge the new branch into the original branch, resolving the trivial conflict by keeping both files.
Restore the original filename in a separate commit.
For v2.8.3 the following should work:
YAMLFactory yf = new YAMLFactory();
ObjectMapper mapper = new ObjectMapper(yf);
ObjectNode root = (ObjectNode) mapper.readTree(yamlFileIn);
// modify root here
FileOutputStream fos = new FileOutputStream(yamlFileOut);
SequenceWriter sw = mapper.writerWithDefaultPrettyPrinter().writeValues(fos);
sw.write(root);
/**
* NOTE: Without this method present and returning LanguageVersion.JAVA_1_5,
* Javadoc will not process generics because it assumes LanguageVersion.JAVA_1_1
* @return language version (hard coded to LanguageVersion.JAVA_1_5)
*/
public static LanguageVersion languageVersion() {
return LanguageVersion.JAVA_1_5;
}
designed to manage user specified directories referred to as sync targets from here on out, in tmpfs and to periodically sync them back to the physical disc (HDD/SSD)
JSON itself does not specify how dates should be represented, but JavaScript does.
You should use the format emitted by Date's toJSON method:
2012-04-23T18:25:43.511Z
As a database developer, you want these sub-transactions or autonomous transactions to be processed and committed regardless of what happens to the larger surrounding transaction block.
The pg_background Postgres extension originally written by Robert Haas starts a separate worker to process a SQL statement, which is a nice way to achieve an autonomous transaction.
If you really want to create an array rather than a list use either
String[] names = ["lucas", "Fred", "Mary"]
or
def names = ["lucas", "Fred", "Mary"].toArray()
E. Pinheiro, W. Weber, и L. Barroso. Proceedings of the 5th USENIX Conference on File and Storage Technologies, стр. 2--2. Berkeley, CA, USA, USENIX Association, (2007)
T. Reps, S. Horwitz, и M. Sagiv. Proceedings of the 22Nd ACM SIGPLAN-SIGACT Symposium on Principles of Programming Languages, стр. 49--61. New York, NY, USA, ACM, (1995)
W. Scholz, T. Thüm, S. Apel, и C. Lengauer. Proceedings of the 15th International Software Product Line Conference, Volume 2, стр. 7:1--7:8. New York, NY, USA, ACM, (2011)
H. Kim, J. Choi, D. Choi, H. Choi, и P. Kim. Proceedings of the 2012 ACM Research in Applied Computation Symposium, стр. 310--315. New York, NY, USA, ACM, (2012)
G. Mishne, и M. de Rijke. Proceedings ot the 7th International Conference on Computer-Assisted Information Retrieval (Recherche d'Information et ses Applications) - RIAO 2004, стр. 539--554. CID, (апреля 2004)
H. Traunmüller. Experiments in speech processes, том XII из Phonetic Experimental Research at the Institute of Linguistics, The Institute of Linguistics, University of Stockholm, Stockholm, (1991)
S. Gulwani, и M. Marron. Proceedings of the 2014 ACM SIGMOD International Conference on Management of Data, стр. 803--814. New York, NY, USA, ACM, (2014)
B. Sacaleanu, и G. Neumann. Proceedings of the Eighth International Conference on Language Resources and Evaluation (LREC-2012), European Language Resources Association (ELRA), (2012)
M. Schuhmacher, и S. Ponzetto. Proceedings of the 7th ACM International Conference on Web Search and Data Mining, стр. 543--552. New York, NY, USA, ACM, (2014)
D. Pavlovic, P. Pepper, и D. Smith. Mathematics of Program Construction, том 6120 из Lecture Notes in Computer Science, Springer Berlin Heidelberg, (2010)
M. Baroni, и R. Zamparelli. Proceedings of the 2010 Conference on Empirical Methods in Natural Language Processing, стр. 1183--1193. Stroudsburg, PA, USA, Association for Computational Linguistics, (2010)
R. Khatchadourian, P. Greenwood, A. Rashid, и G. Xu. Proceedings of the 2009 IEEE/ACM International Conference on Automated Software Engineering, стр. 575--579. Washington, DC, USA, IEEE Computer Society, (2009)
C. Scholz, J. Illig, M. Atzmueller, и G. Stumme. Proceedings of the 25th ACM Conference on Hypertext and Social Media, стр. 279--284. Santiago, Chile, ACM, (сентября 2014)
C. Wang, J. Han, Y. Jia, J. Tang, D. Zhang, Y. Yu, и J. Guo. Proceedings of the 16th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, стр. 203--212. New York, NY, USA, ACM, (2010)
J. Jardine, и S. Teufel. Proceedings of the 14th Conference of the European Chapter of the Association for Computational Linguistics, стр. 501--510. Gothenburg, Sweden, Association for Computational Linguistics, (апреля 2014)
J. Illig, B. Roth, и D. Klakow. Proceedings of the 14th Conference of the European Chapter of the Association for Computational Linguistics, volume 2: Short Papers, стр. 100--105. Gothenburg, Sweden, Association for Computational Linguistics, (апреля 2014)
D. Mollá, и B. Hutchinson. Proceedings of the EACL 2003 Workshop on EvaluationInitiatives in Natural Language Processing: are evaluation methods,metrics and resources reusable?, стр. 43--50. Association for Computational Linguistics, (2003)
Y. Chan, и D. Roth. Proceedings of the 49th Annual Meeting of the Association for Computational Linguistics: Human Language Technologies - Volume 1, стр. 551--560. Stroudsburg, PA, USA, Association for Computational Linguistics, (2011)
M. Banko, M. Cafarella, S. Soderland, M. Broadhead, и O. Etzioni. Proceedings of the 20th International Joint Conference on Artifical Intelligence, стр. 2670--2676. San Francisco, CA, USA, Morgan Kaufmann Publishers Inc., (2007)
H. Poon, и P. Domingos. Proceedings of the 2009 Conference on Empirical Methods in Natural Language Processing: Volume 1 - Volume 1, стр. 1--10. Stroudsburg, PA, USA, Association for Computational Linguistics, (2009)
T. Joachims. Proceedings of the Eighth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, стр. 133--142. New York, NY, USA, ACM, (2002)
C. Danescu-Niculescu-Mizil, R. West, D. Jurafsky, J. Leskovec, и C. Potts. Proceedings of the 22nd international conference on World Wide Web, стр. 307--318. Republic and Canton of Geneva, Switzerland, International World Wide Web Conferences Steering Committee, (2013)
S. Cohen, K. Stratos, M. Collins, D. Foster, и L. Ungar. Proceedings of the 50th Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers), стр. 223--231. Jeju Island, Korea, Association for Computational Linguistics, (июля 2012)
A. Heydarnoori, K. Czarnecki, и T. Bartolomei. ECOOP 2009 – Object-Oriented Programming, том 5653 из Lecture Notes in Computer Science, Springer Berlin Heidelberg, (2009)
Q. He, B. Chen, J. Pei, B. Qiu, P. Mitra, и L. Giles. Proceedings of the 18th ACM conference on Information and knowledge management, стр. 957--966. New York, NY, USA, ACM, (2009)
B. Min, X. Li, R. Grishman, и S. Ang. Proceedings of the Fifth Text Analysis Conference (TAC 2012), National Institute of Standards and Technology (NIST), (ноября 2012)
A. Sun, R. Grishman, W. Xu, и B. Min. Proceedings of the Fourth Text Analysis Conference (TAC 2011), National Institute of Standards and Technology (NIST), (ноября 2011)
E. Alfonseca, K. Filippova, J. Delort, и G. Garrido. Proceedings of the 50th Annual Meeting of the Association for Computational Linguistics: Short Papers - Volume 2, стр. 54--59. Stroudsburg, PA, USA, Association for Computational Linguistics, (2012)
I. Titov, и A. Klementiev. Proceedings of the 49th Annual Meeting of the Association for Computational Linguistics: Human Language Technologies, стр. 1445--1455. Portland, Oregon, USA, Association for Computational Linguistics, (июня 2011)
H. Poon, и P. Domingos. Proceedings of the 2009 Conference on Empirical Methods in Natural Language Processing: Volume 1 - Volume 1, стр. 1--10. Stroudsburg, PA, USA, Association for Computational Linguistics, (2009)
J. Kang, K. Lerman, и L. Getoor. (2013)cite arxiv:1301.6277Comment: The 2013 International Conference on Social Computing, Behavioral-Cultural Modeling, & Prediction (SBP 2013).
R. Reichart, и A. Rappoport. Proceedings of the Thirteenth Conference on Computational Natural Language Learning, стр. 156--164. Stroudsburg, PA, USA, Association for Computational Linguistics, (2009)
D. Tikk, Z. Bánsághi, и G. Biró. Proc. of the 6th Int. Symp. of Hungarian Researchers on Computational Intelligence (HUCI 2005), стр. 267--276. Budapest, Hungary, (ноября 2005)
H. Ji, и R. Grishman. Proceedings of the 49th Annual Meeting of the Association for Computational Linguistics: Human Language Technologies - Volume 1, стр. 1148--1158. Stroudsburg, PA, USA, Association for Computational Linguistics, (2011)