DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
	b=PNGn771AoiMEeoXRefyFQPACtRyaV8Dev5FdTk0YKE24848OKUrkqaG0hIidgy8LqaExFvyUNMcn5kl/hG5P5ID3r0oCQSkfOhrQk06zqVq3ZXYHC8CxjOvKWXD7n19bgD9+dng5C7iZgTp/YD/4w6ToTEMTNj65LIqehxyAYCY=
Message-ID: <ddcb1c340708072250i24e92711w603e350c88e6dbd6@mail.gmail.com>
Date: Wed, 8 Aug 2007 15:50:25 +1000
From: novice <user.postgresql@gmail.com>
To: "Phillip Smith" <phillip.smith@weatherbeeta.com.au>
Subject: Re: populate value of column
Cc: pgsql-sql@postgresql.org
In-Reply-To: <00ec01c7d97e$31c9bd80$9b0014ac@wbaus090>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <ddcb1c340708072230pe7e096bx40fe3e8b348a69de@mail.gmail.com>
	<00ec01c7d97e$31c9bd80$9b0014ac@wbaus090>

Thank you :-))
That's so quick!  Apologies for the error on my DDL statement


On 08/08/07, Phillip Smith <phillip.smith@weatherbeeta.com.au> wrote:
> -----Original Message-----
> From: pgsql-sql-owner@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]
> 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 |         02
> >      1001 |         03
> >      1001 |         04
> >      1012 |         01
> >      1012 |         02
> >      1012 |         03
> >      1012 |         04
> >      1012 |         05
> >      1012 |         06
>
> I even tested this one too ;)
>         SELECT  meter_id,
>                         LPAD(GENERATE_SERIES(1,area_no),2,'0')
>         FROM    meter;
>
> Works on 8.2.4 - you didn't say what version you were using.
>
>
> *******************Confidentiality and Privilege Notice*******************
>
> The material contained in this message is privileged and confidential to
> the addressee.  If you are not the addressee indicated in this message or
> responsible for delivery of the message to such person, you may not copy
> or deliver this message to anyone, and you should destroy it and kindly
> notify the sender by reply email.
>
> Information in this message that does not relate to the official business
> of Weatherbeeta must be treated as neither given nor endorsed by Weatherbeeta.
> Weatherbeeta, its employees, contractors or associates shall not be liable
> for direct, indirect or consequential loss arising from transmission of this
> message or any attachments
>
> THINK BEFORE YOU PRINT - Save paper if you don't really need to print this
> e-mail.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
>