i have a table
CREATE TABLE meter
(
meter_id integer NOT NULL,
no_of_bays integer,
CONSTRAINT meter_pkey PRIMARY KEY (meter_id)
)
INSERT INTO meter(
meter_id, no_of_bays)
VALUES (5397, 2);
INSERT INTO meter(
meter_id, no_of_bays)
VALUES (5409, 3);
select meter_id, no_of_bays from meter;
meter_id | no_of_bays
----------+------------
5397 | 2
5409 | 3
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
--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
