1. Aprender
    2. /
  2. Cursos
    3. /
  3. Functions for Manipulating Data in PostgreSQL
  • 1

    Overview of Common Data Types

    Gratuito

    Learn about the properties and characteristics of common data types including strings, numerics and arrays and how to retrieve information about your database.

  • 2

    Working with DATE/TIME Functions and Operators

    Explore how to manipulate and query date and time objects including how to use the current timestamp in your queries, extract subfields from existing date and time fields and what to expect when you perform date and time arithmetic.

  • 3

    Parsing and Manipulating Text

    Learn how to manipulate string and text data by transforming case, parsing and truncating text and extracting substrings from larger strings.

  • 4

    Full-text Search and PostgresSQL Extensions

    An introduction into some more advanced capabilities of PostgreSQL like full-text search and extensions.

Initializing

Exercicio

User-defined data types

ENUM or enumerated data types are great options to use in your database when you have a column where you want to store a fixed list of values that rarely change. Examples of when it would be appropriate to use an ENUM include days of the week and states or provinces in a country.

Another example can be the directions on a compass (i.e., north, south, east and west.) In this exercise, you are going to create a new ENUM data type called compass_position.

Instruções 1/2

undefined XP
    1
    2
  • Create a new enumerated data type called compass_position.
  • Use the four positions of a compass as the values.