Recently prepared for PostgreSQL database development related knowledge, this article summarizes the PPT content through the blog record sharing, this essay's main content is to introduce the PostgreSQL database basic information, and how to use the
PostgreSQL tutorial (5): Functions and operators (1), postgresql Operators
I. logical operators:
Common logical operators include AND, OR, and not. Its semantics is exactly the same as that of logical operators in other programming languages.
Ii.
: Network Disk DownloadContent Profile ...This book will help you understand and use the PostgreSQL open source database system. Not only will you learn about enterprise features in versions 9.2, 9.3, and 9.4, but you'll also find that PostgreSQL is
PostgreSQL tutorial (6): Functions and operators (2), postgresql Operators
6. Pattern Matching:
PostgreSQL provides three methods for implementing pattern matching: SQL LIKE operator, closer SIMILAR TO operator, and POSIX-style regular expression.1.
One, the logical operator:
The common logical operators are: and, or and not. The semantics are exactly the same as the logical operators in other programming languages.
Second, the comparison operator:
The following is a list of comparison
Vi. Pattern Matching:
PostgreSQL provides three ways to implement pattern matching: SQL Like operator, more recent similar to operator, and posix-style regular expression.1. Like:
Copy Code code as follows:
string like pattern
SQL Server data migration to PostgreSQL error explanation and solution, serverpostgresql
Problem reproduction:
1. PG client:
postgres=# create table text_test (id int,info text);CREATE TABLEpostgres=# insert into text_test values (1,E'\0x00');ERROR:
Function
return type
Describe
Example
Results
string | | String
Text
String connection
' Post ' | | ' Gresql '
PostgreSQL
Bit_length (String)
Int
The number of bits in a
All messages sent by the PostgreSQL server are given a five-character error code that follows the custom of the SQL "SQLSTATE" code. Apps that need to know what error conditions are occurring should usually test the error code instead of the text
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.