pozs questions

pozs answers

• PostgreSQL regular expression
• Making a partition query, reporting the first NOT NULL occurrence within partition before current row (if any)
• Postgres not using partial timestamp index on interval queries (e.g., now() - interval '7 days' )
• Check if timestamp is within tsrange
• Convert value from string representation in base N to numeric
• Error in dynamic statement PL/PGSQL (functions and operators can take at most one set argument)
• How to store regex "literals" in Postgres?
• UTF16 hex to text
• Extract weekday, millisecond, microsecond, nanosecond from a date in Postgres
• Accessing the Return Table in a Postgres Function