Algorithms & Data Structures
Languages
Tools
Tag: SQL
Post-create trigger example (PostgreSQL)
create or replace function after_deferred_entity_created_function()
returns trigger as
$BODY$
begin
if new.parentid isnull
then
update deferredentity set parentid = nextval('entity_id_seq') where id = new.id;
end if;
return NEW;
end;
$BODY$
language plpgsql;
create trigger after_deferred_entity_created_trigger
after insert
on deferredentity
for each row
execute procedure after_deferred_entity_created_function();
Free programming books
Как следует из названия, куча-мала ссылок на бесплатные книги по программированию. Выбор огромен - от ассемблера до JavaScript, от книг по Windows GUI до Spring.
Судя по history, актуальность ссылок активно поддерживается.
Ссылка на GitHub: https://github.com/vhf/free-programming-books/blob/master/free-programming-books.md
compileonline.com
Compile and Execute your favorite programming languages online.
Programming languages: Ada (Gnat), Algol-68, Assembly, Awk, Bash Shell, Basic, Befunge, Brainf**k, C, C99 Strict, COBOL, C++, C++11, C++0x, C#, Clojure, Dart, D Language, Embedded C, Erlang, F#, Factor, Falcon, Fantom, Forth, Fortran-95, Go, Groovy, Haskell, ICON, Intercal, Java, LISP, Lua, Malbolge, MATLAB/Octave, Mozart-OZ, Nimrod, Node.js, Objective-C, OCaml, PARI/GP, Pascal, Pawn, Perl, PHP, Pike, Prolog, Python, Python-3, REXX, R Programming, Ruby, Rust, Scala, Scheme, Simula, Smalltalk, SQLite SQL, Tcl, Unix Shell, Unlambda, VB.Net, Verilog, Whitespace, LOLCODE, Julia, ScriptBasic, BaCon, ilasm, QuickBasic, SML/NJ.
