|
|
|
|
|
|
| |
General Bits is a column loosely based on the PostgreSQL mailing list
pgsql-general.
To find out more about the pgsql-general list and PostgreSQL, see
www.PostgreSQL.org.
|
|
|
Issue # 10 20-Jan-2003
|
|
1
|
Editorial Inquiry
|
|
2
|
Trimming unneeded spaces
|
|
3
|
Perfect Vacuuming
|
|
4
|
Integers, int2, int4 and implicit casting of constants
|
|
5
|
Abstime and epoch casts
|
|
6
|
Matching tables to physical files
|
|
|
Issue # 9 20-Jan-2003
|
|
1
|
Row Locking
|
|
2
|
Optimize file input
|
|
3
|
Turn off triggers for bulk load
|
|
4
|
Temporary tables
|
|
5
|
CREATE TABLE AS with OIDS
|
|
6
|
Tracking down rogue processes
|
|
|
Issue # 8 13-Jan-2003
|
|
1
|
Dropping template1
|
|
2
|
Setting NULL representation for copy
|
|
3
|
Sorting NULLs on top
|
|
4
|
Referential Integrity Update Trigger?
|
|
5
|
Updating from a selection
|
|
6
|
Qualifying Aggregates
|
|
7
|
Hardware Crashes -- by Josh Berkus
|
|
|
Issue # 7 06-Jan-2003
|
|
1
|
2002 Linux New Media Editors Choice Award for Best Database for PostgreSQL
|
|
2
|
7.3.1 Release
|
|
3
|
Character Array Input
|
|
4
|
Who's the super user?
|
|
5
|
Measuring query time
|
|
6
|
DISTINCT operators
|
|
|
Comments and Corrections are welcome. Suggestions and
contributions of items are also welcome.
Send them in!.
Copyright A. Elein Mustain 2003, 2004,2005
|
