From: novice <user.postgresql@gmail.com>
To: Phillip Smith <phillip.smith@weatherbeeta.com.au>
Cc: pgsql-sql@postgresql.org
Subject: Re: populate value of column
Date: Wed, 8 Aug 2007 15:50:25 +1000
Message-ID: <ddcb1c340708072250i24e92711w603e350c88e6dbd6@mail.gmail.com> (raw)
In-Reply-To: <00ec01c7d97e$31c9bd80$9b0014ac@wbaus090>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: user.postgresql@gmail.com, phillip.smith@weatherbeeta.com.au
Subject: Re: populate value of column
In-Reply-To: <ddcb1c340708072250i24e92711w603e350c88e6dbd6@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox