| From: | novice <user(dot)postgresql(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | count question |
| Date: | 2008-04-09 01:51:35 |
| Message-ID: | ddcb1c340804081851y245f4776g9de74b5715e3a3e@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2008-04-09 02:11:39 | Re: count question |
| Previous Message | Tk421 | 2008-04-08 17:39:38 | Re: Pattern Matchig |