| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Pete Forman <pete(dot)forman(at)westerngeco(dot)com>, Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: floating point representation |
| Date: | 2001-02-21 15:59:39 |
| Message-ID: | Pine.LNX.4.30.0102211659170.1381-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Philip Warner writes:
> At 22:29 20/02/01 +0100, Peter Eisentraut wrote:
> >Tom Lane writes:
> >> And we frequently see questions from users about how they can display
> >> fewer digits than the system wants to give them --- or, more
> >> generally, format the output in some special form.
> >
> >to_char() should serve those people.
> >
>
> This is not a good solution if what you want (as a user) is consistency of
> output no matter who retrieves the data; people should not have to wrap
> every SELECT field in to_char to get the precision/format they want.
Views should serve those people.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-02-21 16:10:08 | Re: beta5 ... |
| Previous Message | Karel Zak | 2001-02-21 15:42:20 | Re: Encoding names |