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
* 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, 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
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:
> > *
* 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,
* 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 '...
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
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
* 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:
> 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:
> > 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:
> 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:
> > 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:
> * 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
14 matches
Mail list logo