Category: PostgreSQL

Technology - The Difference Between Float Vs. Double Data Types

The Difference Between Float Vs. Double Data Types

It would be incorrect to say that floating-point numbers should never be used as an SQL data type for arithmetic. I will stick to double-precision floating-point data types for SQL Server that are suitable for my requirements. The double-precision floating-point data type is ideal for modeling weather systems or displaying trajectories but not for the type of calculations the average organization may use in the database. The biggest difference is in the accuracy when creating the database. You need to analyze the data types and fields to ensure no errors and insert the data values for maximum accuracy. If there

Continue reading

What Are The SQL Minus and Except Clauses

Structured Query Language (SQL) is the de-facto query language used in most database management systems (DBMS) such as Oracle and Microsoft SQL Server. This domain-specific language is used in programming to query and return the desired data from a database. We use SQL to write queries that declare what data to expect from a dataset without really indicating how to obtain it. We can also use SQL to update and delete information from a database. Ideally, in a relational database management system, the database usually runs on the “back end” side of a server in its structured form. By itself,

Continue reading

SQL Server Length Function Equivalent

The purpose of the Length function in SQL The SQL LENGTH function returns the number of characters in a string. The LENGTH function is available in many Database Management Systems (DBMS). The LENGTH Function Syntax LENGTH(string) LENGTH Function Notes If the input string is empty, the LENGTH returns 0. If the input string is NULL, the LENGTH returns NULL. Length Function Across Databases When working as a technical consultant, one has to work with customer’s databases and as you move from one database to another you will find that the function commands may vary–assuming the database has an equivalent function.

Continue reading

PostgreSQL Useful Links

If you’re a beginner to PostgreSQL, you’ve probably stumbled upon the various useful links on this page. In addition to the documentation, the PostgreSQL website provides links to third-party vendors, independent groups, and hardware-optimized versions of the database. Not only is this a popular choice for businesses, but many government agencies and other institutions also rely on this open-source database. Embedded SQL Embedded SQL is a feature that allows you to embed SQL statements in your program. This feature requires the host language to be C. A preprocessor is required for embedding SQL in a program, which converts SQL statements

Continue reading

The Business Industries Using PostgreSQL

When it comes to customer size, most PostgreSQL customers are small, with only 14% being large and 59% medium-sized. But even those who are large aren’t the only ones using PostgreSQL. The company claims to have over one million customers in a variety of industries. So how big is PostgreSQL really? Here’s a breakdown of the customer size for each of these categories. One Word Domains There are many companies that use PostgreSQL. Agile Worx, a technology consulting firm, is one of the most successful examples. One Word Domains, a domain name business, uses PostgreSQL to power its products. Boondockers

Continue reading

Netezza / PureData – Substring Function Example

The function Substring (SUBSTR) in Netezza PureData provides the capability to parse character type fields based on position within a character string. Substring Functions Basic Syntax SUBSTRING Function Syntax SUBSTRING(<<CharacterField>>,<< StartingPosition integer>>, <<for Number of characters Integer–optional>>) SUBSTR Function Syntax SUBSTR((<>,<< StartingPosition integer>>, <>) Example Substring SQL Substring SQL Used In Example SELECT  LOCATIONTEXT — From the Left Of the String — — Using SUBSTRING Function ,’==SUBSTRING From the Left==’ as Divider1 ,SUBSTRING(LOCATIONTEXT,1,5) as Beggining_Using_SUBSTRING_LFT ,SUBSTRING(LOCATIONTEXT,7,6) as Middle_Using_SUBSTRING_LFT ,SUBSTRING(LOCATIONTEXT,15) as End_Using_SUBSTRING_LFT ,’==SUBSTR From the Left==’ as Divider2 —Using SUBSTR Function ,SUBSTR(LOCATIONTEXT,1,5) as Beggining_Using_SUBSTR_LFT ,SUBSTR(LOCATIONTEXT,7,6) as Middle_Using_SUBSTR_LFT ,SUBSTR(LOCATIONTEXT,15) as End_Using_SUBSTR_LFT —

Continue reading