开发者

Combine row_number() and string column in Postgres

I need to combine to a string column and the result of a row_number() calculation into one column.

What I've got is column 1, containing string开发者_如何学Pythons and column 2, containing the row_number() result. Now I to combine both into one.

What's the way of this in Postgres? I figured that a simple + or & does not work out.


Figured it out myself:

table.col || ' ' || row_number()... 
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜