altering scale of numeric field

From: "Reshat Sabiq" <sabiq(at)purdue(dot)edu>
To: "'pgsql-novice'" <pgsql-novice(at)postgresql(dot)org>
Subject: altering scale of numeric field
Date: 2002-12-24 03:07:01
Message-ID: 000001c2aaf9$8b330330$0081d380@main
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I believe Oracle allows that and it would look something like:
alter table mytable modify (fee numeric(10,2));
Although I haven't tried this in action.

Since there is no modify subcommand, I tried variations like:
alter table mytable alter column fee set numeric(10,2);

but it appears it's not doable in postgres. Any suggestions?

P.S. I do format it programmatically anyway, but it would be nicer in
long run to have it as 2 decimals in the DB too.

Thanks,
Reshat.

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Tom Lane
Sent: Monday, December 23, 2002 2:49 PM
To: Chad Thompson
Cc: pgsql-novice
Subject: Re: [NOVICE] Comma delimited results

"Chad Thompson" <chad(at)weblinkservices(dot)com> writes:
> Is there a way to display all the results of a row as one big comma
delimit=
> ed string?

In psql, you can do:

regression=# select * from tenk1 limit 2;
unique1 | unique2 | two | four | ten | twenty | hundred | thousand |
twothousand | fivethous | tenthous | odd | even | stringu1 | stringu2 |
string4
---------+---------+-----+------+-----+--------+---------+----------+---
----------+-----------+----------+-----+------+----------+----------+---
------
8800 | 0 | 0 | 0 | 0 | 0 | 0 | 800 |
800 | 3800 | 8800 | 0 | 1 | MAAAAA | AAAAAA | AAAAxx
1891 | 1 | 1 | 3 | 1 | 11 | 91 | 891 |
1891 | 1891 | 1891 | 182 | 183 | TUAAAA | BAAAAA | HHHHxx
(2 rows)

regression=# \a
Output format is unaligned.
regression=# \f ,
Field separator is ','.
regression=# \t
Showing only tuples.
regression=# select * from tenk1 limit 2;
8800,0,0,0,0,0,0,800,800,3800,8800,0,1,MAAAAA,AAAAAA,AAAAxx
1891,1,1,3,1,11,91,891,1891,1891,1891,182,183,TUAAAA,BAAAAA,HHHHxx
regression=#

Dunno if that's quite what you wanted ... but a little digging in the
psql reference page seems warranted ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Kent Rigby 2002-12-24 19:53:52 Moving a database
Previous Message Dave Stewart 2002-12-24 00:31:22 Re: Readline causing grief in build