|
|
|
|
|
|
| |
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 # 27 26-May-2003
|
|
1
|
New Portuguese Articles
|
|
2
|
Clashing Variables Names
|
|
3
|
Table Size and Performance
|
|
4
|
Caching Query Results
|
|
5
|
Grammar for SELECT DISTINCT
|
|
6
|
Looping over an Array
|
|
|
Issue # 26 19-May-2003
|
|
1
|
New Link: General Tidbits
|
|
2
|
RowTypes and Functions Returning Sets
|
|
3
|
Returning Sets
|
|
4
|
Defining and returning Rowtypes
|
|
5
|
Returning Sets of Rows
|
|
6
|
Valid Timezones in PostgreSQL
|
|
|
Issue # 25 13-May-2003
|
|
1
|
Character and Name Sorting
|
|
2
|
Checking up on your installation
|
|
3
|
Requirements for Storing Image Data
|
|
4
|
COPY vs. INSERT for Bulk Load
|
|
5
|
Database space measurement
|
|
|
Issue # 24 05-May-2003
|
|
1
|
Optimizing OR'd Queries
|
|
2
|
Multi-column UPDATES with aggregates
|
|
3
|
Things to consider when allocating space for tables and indexes
|
|
4
|
Fixed Size Column Storage
|
|
5
|
Changing only one of two equal rows
|
|
6
|
Appending to an Array
|
|
|
Comments and Corrections are welcome. Suggestions and
contributions of items are also welcome.
Send them in!.
Copyright A. Elein Mustain 2003, 2004,2005
|
