Combine row_number() and string column in Postgres

Question

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 strings 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.

TRiG · Accepted Answer · 2013-08-21 15:10:17Z

2

Figured it out myself:

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

TRiG

10.7k9 gold badges62 silver badges113 bronze badges

answered Oct 29, 2009 at 11:04

KB22

7,0099 gold badges46 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1