I was playing with some unit tests for PostgresDAC recently. And one test case was to check TPSQLDataset.Locate routine which allows partial-string and case-sensitive matching options. So I want to have some test result set with integer and text columns.…
Pasha Golub's Blog
Nullus est in vitae sensus, ipsa vera est sensus
Blog Archives
Factorial using CTE in PostgreSQL
Not so long ago I used Common Table Expressions for Fibonacci Numbers calculation. Today I had a conversation with one client about SQL in general and about PosgreSQL dialect in particular. We talked about SQL’s Turing completeness also. Well my…
Determination of a leap year in PostgreSQL
From Wikipedia: A leap year (or intercalary or bissextile year) is a year containing one extra day (or, in the case of lunisolar calendars, a month) in order to keep the calendar year synchronized with the astronomical or seasonal year.…
Delete tuple from libpq’s PGresult
I wrote how to modify result set in underlying libpq’s PGresult object with new ones. But there was no solution for deletion. Here I want to propose one solution. The main idea is to copy existing PGresult content to the…
Tagged with: Delphi, development, libpq, libpq.dll, PostgresDAC, PostgreSQL, trick
Posted in Coding, PostgresDAC
Posted in Coding, PostgresDAC
Editing result set using libpq functions
Many of us use libpq client library to access PostgreSQL. And so we do in our PostgresDAC component suite. Very often you don’t want to refresh result set on client side after insert\update\delete some row especially if result set is…
- Database Designer for PostgreSQL 1.9.0 is out! May 17, 2013
- Database Designer for PostgreSQL 1.9.0 Beta 2 available April 15, 2013
- PostgresDAC v2.9.6 is out! May 14, 2013
- PostgresDAC v2.9.5 released April 18, 2013
- PaGoDump and PaGoRestore v9.2.1 released November 23, 2012
- PaGoDump and PaGoRestore v9.1.3 are available June 6, 2012
- Hans-Juergen Schoenig: Kostal Pico to PostgreSQL May 22, 2013
- Jignesh Shah: How to do Postgres Replication and Failover in VMware vFabric Data Director 2.7? May 22, 2013
- Denish Patel: Inserting JSON data into Postgres using JDBC driver May 22, 2013
- Leo Hsu and Regina Obe: KNN GIST with a Lateral twist: Coming soon to a database near you May 22, 2013
- Ian Barwick: "Instant PostgreSQL Starter" review May 21, 2013
