In PostgreSQL, the ASCII() function is used to find the ASCII code for the given characters. This character can be a special character as well.
Education
Professional Postgres and Open Source support
Command Prompt, Inc., is the oldest Postgres Company in North America and one of the oldest Open Source firms still operating today. We serve our clients with best in class expertise and professionalism. You can read more about support and services here:
- Postgres Support
- PgLTS: Extended Support for EOL Postgres
- Open Source Full Stack Support
- Try the latest PgManage (Open Source) and get rid of PgAdmin!
You have landed at the largest single source of Postgres education blogs in the world. At Command Prompt, we believe deeply that the education of the community is critical to the continued success of Postgres and related technologies. We hope you find content you are looking for and don't hesitate to Contact us today for all your Postgres and Open Source consulting and support needs.
PostgreSQL degrees() Function
The degrees() function takes in the angle in radians with double precision data type, and converts and returns the angle value in degrees also having double precision data type.
PL/pgSQL Errors and Messages
Postgres offers several methods to display/show these errors to users and notify them through messages so that the program can be executed normally as expected and without any interruption.
PostgreSQL json_populate_recordset() Function
The json_populate_recordset() function converts the JSON array into a set of data rows. The JSON array can contain multiple JSON objects, which can be converted into arrays by using it.
How Does the pi() Function Work in PostgreSQL?
Use the pi() function in PostgreSQL to get the mathematical constant value of π. pi() can be used in mathematical expressions to use the value of π.
PL/pgSQL Block Structure
PL/pgSQL supports block structure. The block has two sections; a declaration and a body. Sub-block structure is also supported by PL/pgSQL.
PostgreSQL Full-Text Search
In PostgreSQL, the full-text search returns all the possible results for the searched terms and their variants as well which was a drawback of the simple search approach.
SELECT if String Contains a Substring Match in PostgreSQL
SELECT if String Contains a Substring Match in PostgreSQL can be accomplished using different methods, such as LIKE and ILIKE, position(), substring(), etc.
UNION Vs INTERSECT Vs EXCEPT: What's the Difference
In Postgres, the UNION, INTERSECT, and EXCEPT are the set operators that are applied on at least two tables to get a specific combined result.
What Does the UPDATE ... FROM Statement Do in PostgreSQL
In PostgreSQL, the UPDATE FROM statement is used to update the data/row of any table according to the data of another table.
Get Postgres Help!
PgLTS: Extended Support for EOL Postgres
Podcasts
