I believe they are standard PostgreSQL functions not sure what version
they appeared in though.
I learnt about them by RTM
Cheers,
~p
-Original Message-
From: Ronald Rojas [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 14 August 2007 18:00
To: Phillip Smith
Subject: Re: [SQL] populate
Thank you :-))
That's so quick! Apologies for the error on my DDL statement
On 08/08/07, Phillip Smith <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> On Behalf Of novice
> Sent: Wednesday, 8 August 2007 15:31
> To: pgsql-sql@postgres
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_id | bay
> --+
>
