diff options
Diffstat (limited to 'src/test/regress/sql/strings.sql')
| -rw-r--r-- | src/test/regress/sql/strings.sql | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/src/test/regress/sql/strings.sql b/src/test/regress/sql/strings.sql index 2095848a39d..692233793dc 100644 --- a/src/test/regress/sql/strings.sql +++ b/src/test/regress/sql/strings.sql @@ -288,17 +288,17 @@ SELECT replace('yabadabadoo', 'ba', '123') AS "ya123da123doo"; SELECT replace('yabadoo', 'bad', '') AS "yaoo"; -- --- test split +-- test split_part -- -select split('joeuser@mydatabase','@',0) AS "an error"; +select split_part('joeuser@mydatabase','@',0) AS "an error"; -select split('joeuser@mydatabase','@',1) AS "joeuser"; +select split_part('joeuser@mydatabase','@',1) AS "joeuser"; -select split('joeuser@mydatabase','@',2) AS "mydatabase"; +select split_part('joeuser@mydatabase','@',2) AS "mydatabase"; -select split('joeuser@mydatabase','@',3) AS "empty string"; +select split_part('joeuser@mydatabase','@',3) AS "empty string"; -select split('@joeuser@mydatabase@','@',2) AS "joeuser"; +select split_part('@joeuser@mydatabase@','@',2) AS "joeuser"; -- -- test to_hex |