Reputation
5,801
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
10 28
Newest
 sql
Impact
~314k people reached

Oct
20
comment Why does DELETE leave a lingering effect on performance?
I'm going to stop answering questions today. Or whatever it is I'm doing when I type things into that box.
Oct
20
answered Why does DELETE leave a lingering effect on performance?
Oct
18
comment How do I create a user-defined aggregate function?
I don't know. It was documented as "C or C++ (or another language that can use C calling conventions)" in version 5.0. The docs dropped "or another language that can use C calling conventions" in version 5.1. That's a strange phrase to drop.
Oct
18
comment How do I create a user-defined aggregate function?
Either C or C++. Not SQL, anyway.
Oct
11
answered Does my table violate normalization rules?
Oct
11
revised Is there a reason to use extremely abbreviated table names?
Spelling.
Oct
11
comment How to add the aliases to the group by clause
In standard SQL, the dbms is supposed to act like it evaluates the SELECT clause after the GROUP BY clause. That's why the GROUP BY clause can't see aliases in the SELECT clause--they haven't been evaluated (created) yet. I like common table expressions for reducing complexity like this.
Oct
7
awarded  Tag Editor
Oct
7
revised
added 145 characters in body
Oct
6
wiki
Oct
6
suggested approved edit on
Oct
6
revised Splitting a database into multiple databases
edited tags
Oct
6
answered Splitting a database into multiple databases
Oct
4
comment Is the speed of a PostgreSQL SELECT adversely affected by too many indexes on the table?
Usually, when someone says lots of indexes hurt performance, they're talking about insert, update, and delete statements. In short, anything that requires changing the indexes in addition to changing the tables.
Sep
23
comment Is there a tool to check if my database is normalized to the third normal form?
@ack__: No, I don't know of more recent products. It's been ages since I've worked for a place that invested in CASE software.
Sep
23
answered Is there a tool to check if my database is normalized to the third normal form?
Sep
12
comment What is the purpose of the keyword “ID” in PostgreSQL?
It acts as if your GUI tool passed an uppercase column name, including double quotes, to PostgreSQL. (Other things might account for this behavior, but this is the most common one in my experience.) Any time you create a PostgreSQL column name within double quotes, it becomes case-sensitive. In this case, your tool probably created the column "ID" (including the double quotes). PostgreSQL automatically interprets an unquoted column name as lowercase, so in the SELECT query above, it interprets ID as id. And the id column doesn't exist, but "ID" (with quotes) does.
Sep
11
answered What is the purpose of the keyword “ID” in PostgreSQL?
Sep
11
answered Data type for a fuzzy date?
Sep
11
answered Replacing composite key with surrogate