Skip to content

add translate function  #5156

@l1t1

Description

@l1t1

What happens?

duckdb needs add the funciton that postgresql 15
it replace parameter1 each char in parameter 2 with that postision in parameter 3

To Reproduce

D select translate('12','2','a')x;
Error: Catalog Error: Scalar Function with name translate does not exist!
Did you mean "replace"?
LINE 1: select translate('12','2','a')x;

postgresql 15

postgres=# select translate('12','2','a')x;
 x
----
 1a

OS:

windows 7

DuckDB Version:

0.51

DuckDB Client:

CLI

Full Name:

lutao

Affiliation:

study

Have you tried this on the latest master branch?

  • I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

  • I agree

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions