| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Andy Marden <amarden(at)usa(dot)net> |
| Cc: | Jan Wieck <janwieck(at)yahoo(dot)com>, Martijn van Oosterhout <kleptog(at)svana(dot)org>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Casting Varchar to Numeric |
| Date: | 2001-12-10 22:16:45 |
| Message-ID: | 20011210141234.H70079-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 5 Dec 2001, Andy Marden wrote:
> The whole point is that someone should be able to pick up PostgreSQL
> and use it. All this rigmorole is not well documented. What is wrong
> with the equivalent of Oracle's to_char and to_number? It works and
> hasn't caused anyone, to my knowledge, sleepless nights. Sure it's
> great re the extra types and ability to cast via different routes, but
> don't scare people off at the first hurdle! This flexibility should be
> a bonus not a requirement.
AFAICS 7.1.3 and 7.2 both describe a to_number that converts text to
numeric although I haven't used them. But that's still different from
casting.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | wsheldah | 2001-12-10 22:26:49 | Re: Need SQL help, I'm stuck. |
| Previous Message | Jason Earl | 2001-12-10 22:15:16 | Re: use BLOBS or use pointers to files on the filesystem? |