Stephen Frost <[EMAIL PROTECTED]> writes:
> * Tom Lane ([EMAIL PROTECTED]) wrote:
>> You can do any amount of processing you want in an INSERT statement,
>> though.
> Certainly, but for bulk loads that requires more pre-processing work for
> the user and I believe results in more work for the serv
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > No, I'm interested, as I discussed in my message[1], in the ability to
> > use functions in a copy statement to allow me to specify the conversion
> > from text to the appropriate data type.
>
> COPY is not inten
Stephen Frost <[EMAIL PROTECTED]> writes:
> No, I'm interested, as I discussed in my message[1], in the ability to
> use functions in a copy statement to allow me to specify the conversion
> from text to the appropriate data type.
COPY is not intended to be that flexible; it's intended to be fast.
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > I guess my example was lacking, I'm sure there are cases where the
> > text->date casting will end up being wrong or some date style won't be
> > accepted. If the above was 'January 10th, 2003, October 1st, 2003,
Stephen Frost <[EMAIL PROTECTED]> writes:
> I guess my example was lacking, I'm sure there are cases where the
> text->date casting will end up being wrong or some date style won't be
> accepted. If the above was 'January 10th, 2003, October 1st, 2003,
> January 1st, 2003', for example. Thinking
* Tom Lane ([EMAIL PROTECTED]) wrote:
> Stephen Frost <[EMAIL PROTECTED]> writes:
> > Consider the following input data:
> > 1234,24.50,10-Jan-2003,10/1/03,10-01-2003,hiall
>
> > The interpretation for the numbers is:
> > 1234 =3D 12.34, 24.50 =3D 24.50
> > The interpretation for the dat
Stephen Frost <[EMAIL PROTECTED]> writes:
> Consider the following input data:
> 1234,24.50,10-Jan-2003,10/1/03,10-01-2003,hiall
> The interpretation for the numbers is:
> 1234 =3D 12.34, 24.50 =3D 24.50
> The interpretation for the dates is:
> January 10th, 2003, October 1st, 2003, Oc
Stephen,
You can do whatever you can do with an insert now, so yes, I think that
is possible. Even if the current patch doesn't do that, it would
certainly be a start.
Dave
On Thu, 2003-11-27 at 10:21, Stephen Frost wrote:
> * Dave Cramer ([EMAIL PROTECTED]) wrote:
> > There is a patch floating
* Dave Cramer ([EMAIL PROTECTED]) wrote:
> There is a patch floating around for informix load/unload
>
> the syntax is load from 'file' insert into , and unload to 'file'
> select "whatever you like"
>
> Would this solve the problem?
I'm not sure. It depends on what you can do with the '...
* Rod Taylor ([EMAIL PROTECTED]) wrote:
> How about COPY into a TEMP TABLE for 10k lines, then do an
> insert into real_table select from temp_table;
> which converts the data?
>
> You could of course thread the load so 2 or 3 processes execute the data
> import.
Sure, this would work,
There is a patch floating around for informix load/unload
the syntax is load from 'file' insert into , and unload to 'file'
select "whatever you like"
Would this solve the problem?
Dave
On Thu, 2003-11-27 at 09:38, Rod Taylor wrote:
> On Thu, 2003-11-27 at 09:28, Stephen Frost wrote:
> > *
On Thu, 2003-11-27 at 09:28, Stephen Frost wrote:
> * Bruno Wolff III ([EMAIL PROTECTED]) wrote:
> > On Thu, Nov 27, 2003 at 09:15:20 -0500,
> > Stephen Frost <[EMAIL PROTECTED]> wrote:
> > > I don't believe it's possible, currently, to correctly import this
> > > data with copy. I'm not sur
* Bruno Wolff III ([EMAIL PROTECTED]) wrote:
> On Thu, Nov 27, 2003 at 09:15:20 -0500,
> Stephen Frost <[EMAIL PROTECTED]> wrote:
> > I don't believe it's possible, currently, to correctly import this
> > data with copy. I'm not sure the date fields would even be accepted
> > as date field
On Thu, Nov 27, 2003 at 09:15:20 -0500,
Stephen Frost <[EMAIL PROTECTED]> wrote:
>
> I don't believe it's possible, currently, to correctly import this
> data with copy. I'm not sure the date fields would even be accepted
> as date fields. It'd be nice if this could be made to work. Fro
Hi,
Consider the following input data:
1234,24.50,10-Jan-2003,10/1/03,10-01-2003,hiall
The interpretation for the numbers is:
1234 = 12.34, 24.50 = 24.50
The interpretation for the dates is:
January 10th, 2003, October 1st, 2003, October 1st, 2003
I don't believe it's possible, cur
15 matches
Mail list logo
