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: | Raw Message | Whole Thread | 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 |