3,317 reputation
720
bio website petereisentraut.blogspot.com
location Pennsylvania
age 34
visits member for 2 years, 4 months
seen 2 days ago
stats profile views 137

PostgreSQL and Debian hacker, DBA at MeetMe


Jan
4
comment When to use NULL and when to use an empty string?
It is actually not the case that NULL != NULL, because that's NULL. ;-)
Jan
4
comment When to use NULL and when to use an empty string?
@Patrick: Using null values can also save space.
Jan
4
answered NULL or NOT NULL by default?
Jan
4
comment NULL or NOT NULL by default?
This is not necessarily true in PostgreSQL. Null columns save space, which can improve speed, and processing time should be about the same.
Jan
4
answered Do higher normalized forms always meet the criteria of lower ones?
Jan
4
comment What is an effective way of labeling columns in a database?
@Spredzy: I would just go with the redundancy.
Jan
3
answered What is an effective way of labeling columns in a database?
Jan
3
awarded  Supporter
Jan
3
awarded  Teacher
Jan
3
answered Is there a good way to run a trigger for each record in a postgres table?
Jan
3
awarded  Autobiographer
Jan
3
answered What is the difference between PostgreSQL 9.0 Replication and Slony-I?