Postgresql only select letters from a column

ShrimpPhaser 发表于 Dev

RandomPerson

So I have this column which contains the street address and the house number, they are both kept in the same column.

Eg: Boulevard 123

Now I want to separate the letters from the numbers so I get "Boulevard" and "123" separately trough a select statement.

How can I do this, using reg expressions?

Thanks in advance

Mureinik

One way of doing this is by using regexp_split_to_array to split the value by the space:

SELECT address_arr[1] AS streer_name, address_arr[2] AS street_number
FROM   (SELECT REGEXP_SPLIT_TO_ARRY(address, ' ') AS address_arr
        FROM   my_table) t

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。

编辑于2021-02-15

我来说两句

0条评论

登录后参与评论

上一篇：如何在MFC项目中打开GDI + 1.1而不是1.0？

来自分类Dev

PostgreSQL - column value changed - select query optimization

来自分类Dev

在postgresql中插入…值（SELECT…FROM…）吗？

来自分类Dev

INSERT INTO MySQL表SELECT FROM PostgreSQL表

来自分类Dev

Postgresql select from results in for loop like

来自分类Dev

PHP SELECT COLUMN中的Postgresql结果为null

来自分类Dev

Exclude a column from a select using LINQ

来自分类Dev

Select same fields from multiple tables using postgresql

来自分类Dev

Change column name from aggregate function default postgresql

来自分类Dev

Select only n number of characters from VARCHAR(MAX) field

来自分类Dev

Select single column as list from existing list using fieldname as string

来自分类Dev

Get pages that are only under letters in category

来自分类Dev

PostgreSQL SELECT 输出参数

来自分类Dev

Postgresql order by column and by timestamp

来自分类Dev

Disallow only whitespaces or show alert only if the user types letters

来自分类Dev

相当于SELECT * FROM table WHERE column1 = column2的熊猫

来自分类Dev

PostgreSQL single query SELECT single row FROM two tables without JOIN

来自分类Dev

SELECT column_name FROM（选择TABLE_NAME FROM TABLE_OF_TABLES）

来自分类Dev

使用SELECT基于SELECT结果的PostgreSQL INSERT

来自分类Dev

PostgreSQL：SELECT DISTINCT与SELECT DISTINCT ON（id）

来自分类Dev

PostgreSQL 9.5 SELECT 中的多个 SELECT

来自分类Dev

PostgreSQL在Select语句上联接

来自分类Dev

从SELECT RETURNING ID插入PostgreSQL

来自分类Dev

PostgreSQL性能-SELECT与存储函数

来自分类Dev

PostgreSQL从SELECT插入附加列

来自分类Dev

PostgreSQL插入的行与select不同

来自分类Dev

PostgreSQL从SELECT插入附加列

来自分类Dev

重写PostgreSQL的Select SQL查询

来自分类Dev

POSTGRESQL - SELECT 更新和条件

来自分类Dev

<display：column + <html：select

Related 相关文章

文章