CYBERTEC PostgreSQL Logo

Tag: sql help

Get the Newest PostgreSQL Info, Tips & Tricks
Here you can find all blog posts about the Tag: sql help. You can go back to all blog posts or take a look into our other categories & tags.

Fuzzy search unleashed

by Hans-Jürgen Schönig | 08.2015
There are still many people out there who cannot spell the name of their favorite database. “PostgreSQL”, “PostgresSQL”, “Postgre SQL” […]

Transactional DDLs

by Hans-Jürgen Schönig | 07.2015
When checking out the new features of Sybase 15.7 (yes, from time to time I get around to see what […]

DROP TABLE: Killing shared_buffers

by Hans-Jürgen Schönig | 06.2015
UPDATED August 2023: Tuning shared_buffers in PostgreSQL is a pretty fundamental thing to do when you set up a high-performance […]

PostgreSQL 9.4 aggregate filter clauses: They do pay off

by Hans-Jürgen Schönig | 02.2015
In my previous posting on PostgreSQL 9.4 I wrote about aggregate FILTER clauses, which are a neat way to make […]

Partial aggregation: The beautiful way

by Hans-Jürgen Schönig | 02.2015
Partial aggregation: Aggregations are a fundamental feature of SQL. Functions such as min, max, count, sum, avg and so on […]

CREATE CAST: Casting integer to IP in PostgreSQL

by Hans-Jürgen Schönig | 05.2014
Once in a while, you have to juggle around with IP addresses and store them / process them in an […]

Regular expressions unleashed in PostgreSQL

by Hans-Jürgen Schönig | 04.2014
When cleaning up some old paperwork this weekend I stumbled over a very old tutorial on regular expressions. In fact, […]

Fed up with long WHERE-clauses?

by Hans-Jürgen Schönig | 12.2013
SQL is a very easy to use language and it is pretty easy to make things work out of the […]

Making random() deterministic - random generator in PostgreSQL

by Hans-Jürgen Schönig | 12.2013
Basically the idea of a random generator is to generate random data – ideally a lot of random and non-deterministic […]

PostgreSQL: Finding Christmas presents

by Hans-Jürgen Schönig | 12.2013
Christmas is approaching fast so I thought I'd give PostgreSQL users some inspiration when it comes to buying their Christmas […]
1 … 11 12 13 14 15
CYBERTEC Logo white
CYBERTEC PostgreSQL International GmbH
Römerstraße 19
2752 Wöllersdorf
Austria

+43 (0) 2622 93022-0
office@cybertec.at

STAY TUNED WITH OUR NEWSLETTER
Get the newest PostgreSQL Info & Tools


    This site is protected by reCAPTCHA and the Google Privacy Policy & Terms of Service apply.

    ©
    2024
    CYBERTEC PostgreSQL International GmbH
    phone-handsetmagnifiercrosscross-circle
    linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram