On Thu, May 14, 2015 at 01:02:01PM -0400, Bruce Momjian wrote:
> On Sun, Feb 10, 2013 at 06:27:02PM -0500, Tom Lane wrote:
> > Jeremy Lowery writes:
> > > I load and dump text files with currency values in it. The decimal in
> > > these
> > > input and output formats in implied. The V format char
On Sun, Feb 10, 2013 at 06:27:02PM -0500, Tom Lane wrote:
> Jeremy Lowery writes:
> > I load and dump text files with currency values in it. The decimal in these
> > input and output formats in implied. The V format character works great for
> > outputing numeric data:
>
> > # select to_char(123.
Jeremy Lowery writes:
> I load and dump text files with currency values in it. The decimal in these
> input and output formats in implied. The V format character works great for
> outputing numeric data:
> # select to_char(123.45, '999V99');
> to_char
> -
> 12345
> (1 row)
> However,
On 10 February 2013 20:50, Jeremy Lowery wrote:
> I load and dump text files with currency values in it. The decimal in
> these input and output formats in implied. The V format character works
> great for outputing numeric data:
>
> # select to_char(123.45, '999V99');
> to_char
> -
>
I load and dump text files with currency values in it. The decimal in these
input and output formats in implied. The V format character works great for
outputing numeric data:
# select to_char(123.45, '999V99');
to_char
-
12345
(1 row)
However, when importing data, the V doesn't do th