Login Register Actian.com  

Actian Community Wiki

Navigation
Learn About
Developing With
Ingres Talk
Information
Toolbox

REPEAT/REPLICATE scalar function

From Ingres Community Wiki

Jump to: navigation, search

Contents

Overview

REPEAT (or REPLICATE) is supported by a number of DBMSs for repeating patterns of data,

Scope

ADF Changes

  • Addition of the function instance and supporting routine.

PSF Changes

  • The parser will need extending to handle REPEAT in a function name context as it is also a keyword.

OPF Changes

None needed

QEF Changes

None needed

SCF Changes

None needed

Front End

None needed

Ingres Update

Change Info

Bug# : 125419
IP : http://reviewboard.ingres.prv/r/9489/
SVN Rev : 4342

QA

Documentation

In the syntax description, c1 denotes a character string.

REPEAT REPEAT(c1, n) Result type: Any character or Unicode type except the long forms. Returns c1 repeated n times. REPLICATE is a synonym for REPEAT. Note: This function does not support LONG VARCHAR and LONG NVARCHAR arguments.

Personal tools
© 2011 Actian Corporation. All Rights Reserved