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
>