Re: Formatting Function..
От | mike g |
---|---|
Тема | Re: Formatting Function.. |
Дата | |
Msg-id | 1089006583.12564.34.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Formatting Function.. (mike g <mike@thegodshalls.com>) |
Список | pgsql-general |
Then again varchar might not keep the padded blanks by default. Perhaps casting to a char data type would be better. On Mon, 2004-07-05 at 00:44, mike g wrote: > 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 > >
В списке pgsql-general по дате отправления: