Re: Formatting Function..

Hi..
This is not the case...Actually I am not using VARCHAR...I am using my
own data type named INDCHAR...Now i want to display it according to
user supplied length..For casting I will have to add more
functionalities which involves a lot of coding...
I was looking for some function (if one exists) which just reserves a
perticular length in terms of either pixels or characters...

Thanks

On Mon, 5 Jul 2004 17:05:26 +1000, Andrew Bartley
<abartley(at)evolvosystems(dot)com> wrote:
> Hi Vinay
>
> Using cast will pad the output with blanks.
>
> Do you want to dynamically change the length of the name column?
>
> Thanks
>
> Andrew
>
>
>
>
> -----Original Message-----
> From: Vinay Jain [mailto:vinayjain(at)gmail(dot)com]
> Sent: Monday, 5 July 2004 4:53 PM
> To: abartley(at)evolvosystems(dot)com
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Formatting Function..
>
> Hi...
> Thanks for response
> I don't want casting... ...is this the only solution..
>
> Regards
> Vinay
>
> On Mon, 5 Jul 2004 16:17:53 +1000, Andrew Bartley
> <abartley(at)evolvosystems(dot)com> wrote:
> > To format the column names you could try
> >
> > select cast(name as char(desired length)) as "Name", age as "Age" from
> > student;
> >
> >
> >
> > -----Original Message-----
> > From: pgsql-general-owner(at)postgresql(dot)org
> > [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of mike g
> > Sent: Monday, 5 July 2004 3:44 PM
> > To: Vinay Jain
> > Cc: pgsql-general(at)postgresql(dot)org
> > Subject: Re: [GENERAL] Formatting Function..
> >
> > Perhaps,
> >
> > select cast(name as varchar(desired length)) as name, age from student;
> >
> > Mike
> > On Mon, 2004-07-05 at 00:19, Vinay Jain wrote:
> > > Hi..
> > > I am newbe in postgresql so please help me though the question may be
> > > very easy to answer..
> > > Is there any formatting function to get output with fix lengths..for
> > > example my query is..
> > > schema is:
> > >
> > > Student
> > > (name Varchar,
> > > age integer);
> > >
> > > select name, age from student;
> > > the output is like this..
> > > Name | Age
> > > xyz | 22
> > >
> > > I want this length of name to be of my choice...is it possible..& how..
> > >
> > > thanks in advance
> > > Regards
> > > Vinay
> > >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/docs/faqs/FAQ.html
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 7: don't forget to increase your free space map settings
> >
>
> --
> Vinay Jain
> Dissertation Project Trainee
> DAKE Division
> C-DAC Mumbai
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>

--
Vinay Jain
Dissertation Project Trainee
DAKE Division
C-DAC Mumbai