Logo
latest

Contents:

  • Getting Started
    • Preparing Your Machine to Install SQream
    • Installing SQreamDB
    • Executing Statements in SQreamDB
    • Performing Basic SQream Operations
      • Running the SQream SQL Client
      • Creating Your First Table
      • Listing Tables
      • Inserting Rows
      • Running Queries
      • Deleting Rows
      • Saving Query Results to a CSV or PSV File
    • Hardware Guide
    • Staging and Development Hardware Guide
  • Installation Guides
    • Installing and Launching SQream
      • Recommended Pre-Installation Configuration
      • Installing SQream Using Binary Packages
      • Installing Monit
      • Launching SQream with Monit
    • Installing SQream Studio
      • Installing Prometheus Exporter
      • Installing Prometheus Using Binary Packages
      • Installing the Dashboard Data Collector
      • Installing Studio on a Stand-Alone Server
      • Installing an NGINX Proxy Over a Secure Connection
  • System Architecture
    • Internals and Architecture
    • Filesystem and Usage
    • Sizing
  • Configuration Guides
    • Configuring SQream
      • Cluster and Session
      • Workers
      • Modification Methods
      • Parameter Values
      • Showing All Flags in the Catalog Table
    • Spooling Configuration
    • Configuring LDAP authentication
  • Operational Guides
    • Access Control
      • Overview
      • Password Policy
      • Managing Roles
      • Permissions
      • Departmental Example
    • Creating or Cloning Storage Clusters
    • Working with External Data
      • Inserting Data Using Amazon S3
      • Using SQream in an HDFS Environment
    • Foreign Tables
    • Deleting Data
    • Logging
    • Monitoring Query Performance
    • Security
    • Saved Queries
    • Seeing System Objects as DDL
    • Optimization and Best Practices
  • Connecting to SQreamDB
    • Client Platforms
      • Denodo Platform
      • Informatica Cloud Services
      • MicroStrategy
      • Pentaho Data Integration
      • BI Desktop
      • R
      • SAP BusinessObjects
      • SAS Viya
      • SQL Workbench
      • Tableau
      • Talend
      • TIBCO Spotfire
    • Client Drivers
      • JDBC
      • Python (pysqream)
      • Node.JS
      • ODBC
        • Install and Configure ODBC on Windows
        • Install and configure ODBC on Linux
      • .NET
  • SQream Acceleration Studio 5.4.7
    • Getting Started with SQream Acceleration Studio 5.4.7
    • Monitoring Workers and Services from the Dashboard
    • Executing Statements and Running Queries from the Editor
    • Viewing Logs
    • Creating, Assigning, and Managing Roles and Permissions
    • Configuring Your Instance of SQreams
  • Feature Guides
    • Automatic Foreign Table DDL Resolution
    • Query Healer
    • Compression
    • Python UDF (User-Defined Functions)
    • Workload Manager
    • Concurrency and Locks
  • Data Ingestion Sources
    • Overview
    • Avro
    • CSV
    • Parquet
    • ORC
    • JSON
    • External Databases
  • External Storage Platforms
    • Azure
    • Google Cloud Platform
    • Using SQream in an HDFS Environment
    • Inserting Data Using Amazon S3
  • References
    • SQL Statements and Syntax
      • SQL Syntax Features
      • SQL Statements
      • SQL Functions
        • Built-In Scalar Functions
        • User-Defined Functions
        • Aggregate Functions
        • Window Functions
    • Catalog Reference Guide
      • Overview
      • What Information Does the Schema Contain?
      • Catalog Tables
      • Additional Tables
      • Examples
    • Command line programs
      • metadata_server
      • sqreamd
      • sqream-console
      • Server Picker
      • SqreamStorage
      • sqream sql
      • upgrade_storage
    • SQL Feature Checklist
  • Data Types
    • Supported Data Types
      • Primitive Data Types
      • Array
    • Casts and Conversions
    • Supported Casts
      • Numeric
      • Boolean
      • Integer
      • Floating Point
      • String
      • Date
  • Release Notes
    • 4.0 Release Notes
      • Release Notes 4.0
      • Release Notes 4.1
      • Release Notes 4.2
      • Release Notes 4.3
      • Release Notes 4.4
    • Release Notes 2022.1
      • Release Notes 2022.1.7
      • Release Notes 2022.1.6
      • Release Notes 2022.1.5
      • Release Notes 2022.1.4
      • Release Notes 2022.1.3
      • Release Notes 2022.1.2
      • Release Notes 2022.1.1
      • Release Notes 2022.1
    • Release Notes 2021.2
      • Release Notes 2021.2.1.24
      • Release Notes 2021.2.1
      • Release Notes 2021.2
  • Troubleshooting
    • Remedying Slow Queries
    • Resolving Common Issues
    • Identifying Configuration Issues
    • Lock Related Issues
    • Log Related Issues
    • Core Dumping Related Issues
    • Retrieving Execution Plan Output Using SQreamDB Studio
    • Gathering Information for SQream Support
  • Glossary
SQream DB
  • RIGHT

RIGHT

Returns the right part of a character string with the specified number of characters.

See also LEFT.

Syntax

RIGHT( expr , character_count )

Arguments

Parameter

Description

expr

String expression

character_count

The number of characters to be returned. If character_count <= 0, an empty string is returned.

Returns

Returns the same type as the argument supplied.

Notes

  • This function works on TEXT strings only.

  • If the value is NULL, the result is NULL.

Examples

For these examples, consider the following table and contents:

CREATE TABLE jabberwocky(line TEXT(50));

INSERT INTO jabberwocky VALUES
   ('''Twas brillig, and the slithy toves '), ('      Did gyre and gimble in the wabe: ')
   ,('All mimsy were the borogoves, '), ('      And the mome raths outgrabe. ')
   ,('"Beware the Jabberwock, my son! '), ('      The jaws that bite, the claws that catch! ')
   ,('Beware the Jubjub bird, and shun '), ('      The frumious Bandersnatch!" ');

Using RIGHT

t=> SELECT LEFT(line, 10), RIGHT(line, 10) FROM jabberwocky;
left       | right
-----------+-----------
'Twas bril | thy toves
      Did  | the wabe:
All mimsy  | orogoves,
      And  | outgrabe.
"Beware th | , my son!
      The  | at catch!
Beware the |  and shun
      The  | rsnatch!"

© Copyright 2023 SQream. Revision a7c74038.

SQream DB v: latest
Versions
latest
2022.1.7
2022.1.6
2022.1.5
2022.1.4
2022.1.3
2022.1.2
2022.1.1
2022.1
2021.2.1.24
2021.2
4.4
4.3
4.2
4.1
4.0
blue
Downloads
pdf
html