1
edit
Changes
→General Research
|-
|What encoding (UTF-8 and/or UTF-16) does PostgreSQL use for unicode? Can this be configured per column?
|UTF-8
|-
| How is a repeatable read with exclusive lock implemented?
|-
|Does to_timestamp support milliseconds?
| '''YES'''Also supports microseconds
|-
| Does postgreSQL have constants for boolean values?
|'''YES'''TRUE and FALSE
|-
| Does posrgreSQL jdbc driver support returning metadata in UpperCase
| '''NO'''Since database objects are case sensitive, returning UpperCase would make for corrupt dataMay be consider changing SQLManager to enforce all database object names to be lowercase
|-
| Does renaming a column cause error if a view depends on it?
|'''NO'''View' is updated with to use the new column name
|-
| Does lo.sql unlink large objects when table is truncated?
