marko-jankovic

Chapter 1: Introduction to PL/pgSQL

What is PL/pgSQL?

PL/pgSQL (Procedural Language/PostgreSQL Structured Query Language) is a procedural language used to write functions, triggers, and stored procedures within the PostgreSQL database. It extends SQL by adding control structures such as loops, conditions, and error handling. This allows developers to write more complex database operations and business logic inside the database itself.

Unlike SQL, which is primarily used to query and manipulate data, PL/pgSQL allows for procedural control over how and when those operations occur, making it ideal for tasks such as automation, batch processing, and integrating complex business logic into your database operations.

History and Significance in PostgreSQL

marko-jankovic

1. HTML Fundamentals

HTML Structure and Semantics

• What is HTML?
  HTML (Hypertext Markup Language) is the standard language used to create and design documents on the web. It structures content using elements or tags.

• What are the building blocks of HTML5?
  The building blocks of HTML5 include elements like <header>, <footer>, <section>, <article>, and <nav> which enhance semantic meaning and accessibility.

• What is the purpose of the `` element in HTML?

marko-jankovic

var text = "Gist is a simple way to share snippets and pastes with others.",
    textLength = text.length,
    lastItem = textLength - 1,
    textToArray = text.split("");

for(var i=0; i<textLength/2; i++) {
    textToArray[i] = textToArray.splice(lastItem-i, 1, textToArray[i])[0];
}

console.log(textToArray.join(""));