Blog: Leo Hsu and Regina Obe


208 blogs updated: 1 min. ago
Dollar-quoting for escaping single quotes
PostgreSQL has a feature called dollar-quoting, which allows you to include a body of text without escaping the single quotes. This feature ...
23
18-06-2017 02:43:18 Leo Hsu and Regina Obe PostgreSQL
PostgreSQL JSQuery extension Windows binaries
PostgreSQL JSQuery extension Windows binaries The JSQuery extension is a PostgreSQL extension developed by Postgres Professional. You can ge...
14
13-05-2017 03:21:06 Leo Hsu and Regina Obe PostgreSQL
CASE with set returning functions in PostgreSQL 10
One of the changes coming in PostgreSQL 10 is the ability for the CASE .. WHEN statement to return multiple rows if the expression contains ...
9
09-05-2017 10:16:00 Leo Hsu and Regina Obe PostgreSQL
Composite data types why IS NOT NULL is not the same as NOT IS NULL
With most types you deal with in SQL and more specifically PostgreSQL, when you use a condition such as something IS NULL and it returns fal...
9
29-04-2017 22:26:00 Leo Hsu and Regina Obe PostgreSQL
ODBC FDW now supports 9.5 and 9.6
A while ago when Foreign Data Wrappers in PostgreSQL was a fairly new thing, we talked about the ODBC_FDW foreign data wrapper. Since then, ...
18
23-11-2016 07:11:06 Leo Hsu and Regina Obe PostgreSQL
http extension for windows 64-bit
For those folks on windows who want to do http gets and posts directly from your PostgreSQL server, we've made binaries for the http extensi...
16
11-10-2016 00:54:35 Leo Hsu and Regina Obe PostgreSQL
regexp_split_to_table and string_to_array unnest performance
Whenever you need to split a text into multiple records breaking by some delimeter, there are two common options that PostgreSQL provides. T...
12
02-07-2016 06:32:40 Leo Hsu and Regina Obe PostgreSQL
PLV8 for Breaking Long lines of text
Recently we found ourselves needing to purchase and download Zip+4 from the USPS. Zip+4 provides listing of mailable addresses in the US. We...
8
04-06-2016 07:22:56 Leo Hsu and Regina Obe PostgreSQL
PostgreSQL 9.6 phrase text searching how far apart can you go
We've been playing around with new phrase text feature of full-text PostgreSQL 9.6. In doing so, I was curious how big a number one can desi...
12
31-05-2016 02:11:08 Leo Hsu and Regina Obe PostgreSQL
PLV8 binaries for PostgreSQL 9.6beta1 windows both 32-bit and 64-bit
To celebrate recent release of PostgreSQL 9.6beta1, we've started to experiment with our favorite extensions. For starters, PLV8 (aka PL/Jav...
13
14-05-2016 02:16:45 Leo Hsu and Regina Obe PostgreSQL


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.