user avatar
user avatar
user avatar
jpmc26
  • Member for 9 years, 2 months
  • Last seen more than a month ago
14 votes
Accepted

How do I reraise an exception in a PL/pgSQL EXCEPTION block?

7 votes

Should I explicitly DENY UPDATE to columns that should not be updated?

5 votes
Accepted

How do I find gaps between ranges of numbers?

5 votes
Accepted

Enforce NOT NULL for set of columns with a CHECK constraint only for new rows

3 votes

Invert a Boolean expression which can return UNKNOWN

3 votes

Why would a primary key value change?

3 votes
Accepted

How can I generate all trailing substrings following a delimeter?

2 votes
Accepted

Filter is applied after DISTINCT ON

2 votes
Accepted

Why won't Oracle use the spatial index when JOINing tables? (Or: Why is my query with a spatial JOIN so slow in Oracle?)

2 votes

Filter by using in for SQL Server

2 votes
Accepted

How can I get all of a few users' roles?

0 votes

Creating a Persisted Computed Column with a function

0 votes

Sql Server fails to use index on simple bijection

0 votes
Accepted

Error "In a grant or revoke statement, the user attempted to grant a tablespace quota above the upper limit." when trying to increase user quota