CYBERTEC Logo

Tag: function

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

Optimizing PostgreSQL functions with preloaded libraries

by Hans-Jürgen Schönig | 01.2024
In PostgreSQL, functions and procedures can be written in many different programming languages including but not limited to PL/pgSQL, PL/Perl, […]

Better SQL functions in PostgreSQL v14

by Laurenz Albe | 07.2022
We all know and value SQL functions as a handy shortcut. PostgreSQL v14 has introduced a new, better way to […]

Golden Proportions in PostgreSQL

by Hans-Jürgen Schönig | 01.2021
As CYBERTEC keeps expanding, we need a lot more office space than we previously did. Right now, we have a […]

Composite type performance issues in PostgreSQL

by Hans-Jürgen Schönig | 06.2020
This blog is about table functions and performance. PostgreSQL is a really powerful database and offers many features to make […]

PostgreSQL v12 new feature: optimizer support for functions

by Laurenz Albe | 05.2019
  PostgreSQL commit 74dfe58a5927b22c744b29534e67bfdd203ac028 has added “support functions”. This exciting new functionality that allows the optimizer some insight into functions. […]

Choose plpgsql variable names wisely

by Pavlo Golub | 03.2019
Pavel Stehule recently wrote the post "Don't use SQL keywords as PLpgSQL variable names" describing the situation when internal stored […]

PostgreSQL: Sharing data across function calls

by Hans-Jürgen Schönig | 05.2018
Recently I did some PostgreSQL consulting in the Berlin area (Germany) when I stumbled over an interesting request: How can […]

Window function: Why first_value and last_value are not bugs

by Hans-Jürgen Schönig | 04.2018
SQL is a must, if you want to be a Data Analyst or a Data Scientist. However, every once in […]

Avoiding unnecessary function calls in PostgreSQL

by Hans-Jürgen Schönig | 01.2018
It is possible to write functions in PostgreSQL in almost any widespread language such as Perl, Python or C. In […]

Writing your own aggregation functions

by Hans-Jürgen Schönig | 07.2017
Many people who have used PostgreSQL or SQL in general in a professional or semi-professional way have stumbled across “aggregate […]
1 2
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