novice wrote:
> Is it possible to write a query to produce:
>
> meter_id | no_of_bays | bay_id
> ----------+------------+-----------
> 5397 | 2 | 5397-01
> 5397 | 2 | 5397-02
> 5409 | 3 | 5409-01
> 5409 | 3 | 5409-02
> 5409 | 3 | 5409-03
Sure. One way, not necessarily a particularly clever or efficient way,
is to do a join with:
generate_series(1, (select max(no_of_bays) from meter)) as i
and use a WHERE clause to select for `i <= no_of_bays'
eg:
SELECT meter_id, no_of_bays, meter_id::text||'-'||i::text AS bay_id
FROM meter, generate_series(1, (select max(no_of_bays) from meter)) as i
WHERE i <= no_of_bays;
--
Craig Ringer
