:[EMAIL PROTECTED]
On Behalf Of novice
Sent: Wednesday, 8 August 2007 15:31
To: pgsql-sql@postgresql.org
Subject: [SQL] populate value of column
> How can I generate the following result?
>
> meter_id | bay
> --+
> 1001 | 01
> 1001 |
7 15:31
> To: pgsql-sql@postgresql.org
> Subject: [SQL] populate value of column
>
> > How can I generate the following result?
> >
> > meter_id | bay
> > --+
> > 1001 | 01
> > 1001 | 02
> > 1001 |
On Aug 8, 2007, at 0:30 , novice wrote:
CREATE TABLE meter
(
meter_id integer NOT NULL,
area_no integer NOT NULL,
CONSTRAINT meter_pkey PRIMARY KEY (meter_id)
) ;
INSERT INTO meter(meter_id, no_of_bays) VALUES (1001, 4);
INSERT INTO meter(meter_id, no_of_bays) VALUES (1012, 6);
Your in
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of novice
Sent: Wednesday, 8 August 2007 15:31
To: pgsql-sql@postgresql.org
Subject: [SQL] populate value of column
> How can I generate the following result?
>
> meter
I have a table
CREATE TABLE meter
(
meter_id integer NOT NULL,
area_no integer NOT NULL,
CONSTRAINT meter_pkey PRIMARY KEY (meter_id)
) ;
INSERT INTO meter(meter_id, no_of_bays) VALUES (1001, 4);
INSERT INTO meter(meter_id, no_of_bays) VALUES (1012, 6);
select meter_id, area_no from meter;
