12 Matching Annotations
  1. Apr 2025
    1. Treat object-name columns in the information_schema views as being of type name, not varchar (Tom Lane) § § § Per the SQL standard, object-name columns in the information_schema views are declared as being of domain type sql_identifier. In PostgreSQL, the underlying catalog columns are really of type name. This change makes sql_identifier be a domain over name, rather than varchar as before. This eliminates a semantic mismatch in comparison and sorting behavior, which can greatly improve the performance of queries on information_schema views that restrict an object-name column. Note however that inequality restrictions, for example
  2. Apr 2021
  3. Mar 2021
    1. Usually when people are talking about code being semantically correct, they're referring to the code that accurately describes something.
    2. HTML elements have meaning. "Semantically correct" means that your elements mean what they are supposed to.
    3. Semantically correct usage of elements means that you use them for what they are meant to be used for.
    4. It means that you're calling something what it actually is.
    5. The classic example is that if something is a table, it should contain rows and columns of data. To use that for layout is semantically incorrect - you're saying "this is a table" when it's not.
    6. Fits the ideal behind HTML HTML stands for "HyperText Markup Language"; its purpose is to mark up, or label, your content. The more accurately you mark it up, the better. New elements are being introduced in HTML5 to more accurately label common web page parts, such as headers and footers.