# 0.5.4.4
## Added features
* Added the array functions `arrayAppend_`, `arrayPrepend_`, `arrayRemove_`, `arrayReplace_`, `arrayShuffle_`, `arraySample_`, `arrayToString_`, and `arrayToStringWithNull_` (#770)
## Updated dependencies
* Updated the upper bound on `time` to include `time-1.14`
# 0.5.4.3
## Added features
* Added `pgSelectWith`, a combinator like `selectWith` which allows to nest common table expressions in subqueries (#720).
## Bug fixes
* Added the ability to migrate Postgres' array types (#354).
* Remove dependency on `haskell-src-exts`, which was not in use anymore.
# 0.5.4.2
## Bug fixes
* Fixed an issue where columns of type `Maybe (Vector a)` did not marshall correctly from the database. In particular, querying a `Nothing` would return `Just (Vector.fromList [])` instead (#692).
# 0.5.4.1
## Bug fixes
* Fixed an issue where inexact numeric literals (e.g. Haskell type `Double`) were implicitly converted to Postgres `NUMERIC`, triggering a runtime conversion error (#700).
# 0.5.4.0
## Added features
* Better error messages on column type mismatches (#696).
* Added support for creating and dropping database schemas and associated tables with `createDatabaseSchema`, `dropDatabaseSchema`, and `createTableWithSchema` (#716).
## Documentation
* Make `runBeamPostgres` and `runBeamPostgresDebug` easier to find (#663).
# 0.5.3.1
## Added features
* Loosen some version bounds
# 0.5.3.0
## Bug fixes
* Make sure lateral join names do not overlap
* Fix `bool_or`
## Addded features
* Add `runSelectReturningFirst`
* `IN (SELECT ...)` syntax via `inQuery_`
# 0.5.2.1
## Added features
* Aeson 2.0 support
# 0.5.2.0
## Added features
* New `conduit` streaming variants which work directly in `MonadResource`
* Heterogeneous variant of `ilike_`: `ilike_'`
* Postgres-specific `EXTRACT` fields
* GHC 9.2 and 9.0 support
## Bug fixes
* Throw correct exception for row errors in `conduit` implementation
* Support emitting UUID values in context where type cannot be inferred by Postgres
# 0.5.1.0
## Added features
* `MonadBase` and `MonadBaseControl` instances for `Pg`
## Bug fixes
* Fix possible memory corruption by copying row data
* Remove invalid parentheses emitted by `pgUnnest`
# 0.5.0.0
## Interface changes
* Removed instances for machine-dependent ambiguous integer types `Int` and `Word`
* Fixed types for some functions that only work with `jsonb` and not `json`
## Added features
* Support for `in_` on row values
* Various Postgres regex functions
* Expose `fromPgIntegral` and `fromPgScientificOrIntegral`
* Add `liftIOWithHandle :: (Connection -> IO a) -> Pg a`
* Add `getDbConstraintsForSchemas` to get constraints without relying on the state of the connection
* Poly-kinded instances for `Data.Tagged.Tagged`
* Add `HasDefaultDatatype` for `UTCTime`
* Support for specifically-sized `SqlSerial` integers (`smallserial`, `serial`, `bigserial`)
* Predicate detection for extensions
* `pgArrayToJson` for `array_to_json`
* Extension definition and all functions provided by `uuid-ossp`
* GHC 8.8 support
## Bug fixes
* Only detect primary keys of tables in visible schemas
* Fix emitting of `DECIMAL` type
* Report JSON correct decoding errors instead of throwing `UnexpectedNull`
## Behavior changes
* `runReturningOne` and `runResturningList` now fetch all rows at once instead of using cursors
# 0.4.0.0
# 0.3.2.0
Add `Semigroup` instances to prepare for GHC 8.4 and Stackage nightly
# 0.3.1.0
Add `runBeamPostgres` and `runBeamPostgresDebug` functions.
# 0.3.0.0
Initial hackage beam-postgres