Blog Archives

MERGE in PostgreSQL

Found cool trick how today implement Orable MERGE in PostgreSQL: Oracle statement:   MERGE INTO acme_obj_value d USING ( SELECT object_id         FROM   acme_state_tmp       ) s ON (d.object_id = s.object_id)   WHEN matched

Tagged with: , ,
Posted in Coding, PostgreSQL

Delphi: Warnigs → Errors


Want to force your dev team to address Compiler Warnings rather than ignoring them? Elevate Warnings to Errors: 1) Go to Project Options 2) Under Delphi Compiler, select Hints and Warnings 3) Expand the Output warnings item 4) For each

Tagged with: , ,
Posted in Coding, Delphi

Get PostgreSQL sources using SVN

As you probably know PostgreSQL sources are managed by Git version control system. Which is great, but for me as SVN user it would be much better to get access to the sources using familiar tools, e.g. TortoiseSVN. Mainly because

Tagged with: , , , ,
Posted in Coding, PostgreSQL

Number into words convertion in PostgreSQL

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.

Tagged with: , ,
Posted in Coding, PostgresDAC

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

Tagged with: , , , , ,
Posted in Coding, PostgreSQL

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.

Tagged with: , , , ,
Posted in Coding

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: , , , , , ,
Posted in Coding, PostgresDAC
Map of wandering

Get every new post delivered to your Inbox.

Join 456 other followers