Method | Result |
---|
distinct column
-> For each row returned, return only the unique members of a set.
Think of it as for each row in a projection, concatenate all the column values and return only the strings that are unique.
test_db=# SELECT DISTINCT parent_id, child_id, id FROM test.foo_table ORDER BY parent_id, child_id, id LIMIT 10;
parent_id | child_id | id
-----------+------------+-----------------------------
1000040 | 103 | 1000040|2645405726|0001|103
/** | |
* You might need to import JIRA ssl certificate into your jdk/jre cacerts file: | |
* 1) save JIRA certificate. E.g. in Chrome right click on https icon, click "Certificate information" link. | |
* In "Details" tab, click "Copy to File..." button. | |
* 2) in jdk "bin" folder run: "keytool -importcert -keystore ./cacerts -file /file/from/the/step/above/cacert.crt -trustcacerts -alias jira_ca | |
*/ | |
class JiraMain { | |
static void main(String[] args) { | |
// see https://docs.atlassian.com/jira/REST/latest/ | |
def listWatchers = "https://jira/rest/api/2/issue/PROJ-123/watchers" |
This entire guide is based on an old version of Homebrew/Node and no longer applies. It was only ever intended to fix a specific error message which has since been fixed. I've kept it here for historical purposes, but it should no longer be used. Homebrew maintainers have fixed things and the options mentioned don't exist and won't work.
I still believe it is better to manually install npm separately since having a generic package manager maintain another package manager is a bad idea, but the instructions below don't explain how to do that.
Installing node through Homebrew can cause problems with npm for globally installed packages. To fix it quickly, use the solution below. An explanation is also included at the end of this document.
directives.directive('twitter', [ | |
function() { | |
return { | |
link: function(scope, element, attr) { | |
setTimeout(function() { | |
twttr.widgets.createShareButton( | |
attr.url, | |
element[0], | |
function(el) {}, { | |
count: 'none', |
Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.
$ python -m SimpleHTTPServer 8000
def cli = new CliBuilder().with { | |
usage = 'program [options] <arguments>' | |
header = 'Options:' | |
footer = '-' * width | |
s 'simplest boolean option' | |
b longOpt: 'both', 'boolean option with both longop and shortop' | |
_ longOpt: 'no-shortop-1', 'boolean option without short version 1' |