Join Bill Weinman for an in-depth discussion in this video Concatenating strings, part of PostgreSQL 9 with PHP Essential Training.
Postgres has a few standard ways to concatenate strings.…The most common is using the Concatenation Operator which is standard SQL,…actually most of this is standard SQL.…And so you can take two strings, 'This is a string' and use the SQL…Concatenation operator which for people who are familiar with other languages…it might look strange.…It's two vertical bars which means other things in other languages.…And I will type another strings 'This is another string' and we are putting a…semicolon and these two strings get concatenated and you notice that there is no…space in between, no nothing in between.…
Of course instead of using the Concatenation operator you can use the…Concatenation function and it's simply spelled CONCAT and then instead of that…operator you use a comma and put a closing parentheses at the end.…And the result is exactly the same.…Now if you want to take several strings and have some kind of a separator in…between them, you can use concatenate with separator which is spelled like this…
- Installing PostgreSQL
- Understanding database architecture
- Inserting, updating, and deleting data in a table
- Creating a database library
- Indexing ID fields
- Storing numbers, text, and Boolean values
- Reading data
- Using casts to force type
- Using mathematical functions
- Concatenating strings
- Working with date and time functions and operators
- Defining CRUD
- Using PHP to insert, read, update, and delete rows in a database
Skill Level Beginner
1. Quick Start
2. Creating a Database
3. Data Types
4. Storing and Reading Data
5. SQL Expressions
6. Mathematical Functions and Operators
Using math functions3m 2s
7. String Functions and Operators
8. Date and Time Functions and Operators
9. PHP Interfaces
10. Web Applications
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.