Welcome to Programmers Language v2

ID: 293
PlCodelang: BigQuery
PlGroup: Datum, Zeit
PlItemTitle: Gestriges Datum
Code: SELECT CURRENT_TIMESTAMP() AS today_timestamp , DATE_ADD(CURRENT_DATE(), INTERVAL -1 DAY) AS yesterday_as_date

ID: 294
PlCodelang: BigQuery
PlGroup: Datenmengen
PlItemTitle: Differenzen anzeigen
Code: WITH a AS ( SELECT * FROM UNNEST([1,2,3,4]) AS n ), b AS ( SELECT * FROM UNNEST([4,5,6,7]) AS n ) SELECT * FROM a EXCEPT DISTINCT -- <------------------ SELECT * FROM b

ID: 295
PlCodelang: BigQuery
PlGroup: Datenbank
PlItemTitle: Eine Menge B reduziert um Menge A
Code: -- Siehe BigQuery -> Differenzen anzeigen -- https://proglang.meta-grid.com/index.php?r=plItems/view&id=294

ID: 296
PlCodelang: EXASOL
PlGroup: Datenmengen
PlItemTitle: Differenzen anzeigen
Code: WITH a AS ( SELECT 1 AS n UNION ALL SELECT 2 AS n UNION ALL SELECT 3 AS n UNION ALL SELECT 4 AS n ), b AS ( SELECT 4 AS n UNION ALL SELECT 5 AS n UNION ALL SELECT 6 AS n UNION ALL SELECT 7 AS n ) SELECT * FROM a EXCEPT -- <------------------------------ SELECT * FROM b

ID: 297
PlCodelang: BigQuery
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: SELECT FORMAT_TIMESTAMP("%FT%H:%M:%E3S", CURRENT_DATETIME()) AS iso_date_string

ID: 298
PlCodelang: EXASOL
PlGroup: Datum, Zeit
PlItemTitle: Aktuelles Datum/Uhrzeit
Code: SELECT TO_CHAR(CURRENT_TIMESTAMP, 'YYYY-MM-DDTHH24:MI:SS.FF3') AS iso_date_string

ID: 299
PlCodelang: PL/pgSQL
PlGroup: Datenbank
PlItemTitle: Alle Datenbanken
Code: SELECT "oid", datname, -- database name datdba, "encoding", datcollate, datctype, datistemplate, datallowconn, datconnlimit, datlastsysoid, datfrozenxid, datminmxid, dattablespace, datacl FROM pg_catalog.pg_database WHERE datistemplate = FALSE -- do not list template0, template1, ... ;

ID: 300
PlCodelang: BigQuery
PlGroup: Datenbank
PlItemTitle: UPDATE SQL mit JOIN
Code: UPDATE `project.dataset.table1` t1 SET t1.target_column = t2.source_column FROM `project.dataset.table2` t2 WHERE t1.join_key = t2.join_key;

ID: 301
PlCodelang: PL/pgSQL
PlGroup: Array
PlItemTitle: Über alle Array-Elemente interieren
Code: DO $do$ DECLARE m text[]; arr text[] := '{{key1,val1},{key2,val2}}'; -- array literal BEGIN FOREACH m SLICE 1 IN ARRAY arr LOOP RAISE NOTICE 'another_func(%,%)', m[1], m[2]; END LOOP; END $do$; -- --------------------------------------------------------- DO $do$ DECLARE i text; arr text[] := '{key1,key2}'; -- array literal BEGIN FOREACH i IN ARRAY arr LOOP RAISE NOTICE 'another_func(%)', i; END LOOP; END $do$;

ID: 302
PlCodelang: Yii2
PlGroup: Sessions
PlItemTitle: Werte in Session speichern und lesen
Code: \Yii::$app->session->set('user.attribute',$value); \Yii::$app->session->get('user.some_attribute');