On Thu, Sep 15, 2005 at 05:09:51PM -0400, Kevin Murphy wrote:
> Neil Conway wrote:
>
> >Kevin Murphy wrote:
> >
> >>I just wanted to confirm that the COPY command always stores data in
> >>the table in the order in which it appears in the import file.
> >
> >This is not the case -- depending on t
Neil Conway wrote:
Kevin Murphy wrote:
I just wanted to confirm that the COPY command always stores data in
the table in the order in which it appears in the import file.
This is not the case -- depending on the content of the FSM, the newly
added rows might be distributed throughout the t
Kevin Murphy wrote:
I just wanted to confirm that the COPY command always stores data in the
table in the order in which it appears in the import file.
This is not the case -- depending on the content of the FSM, the newly
added rows might be distributed throughout the table.
-Neil
---
Kevin Murphy <[EMAIL PROTECTED]> writes:
> Are the two following options equivalent?
> OPTION A (ordered insert):
> CREATE TABLE table1 (cluster_col TEXT, col2 INTEGER);
> CREATE INDEX idx1 ON table1(cluster_col);
> INSERT INTO table1 (cluster_col, col2) SELECT cluster_col, col2 FROM
> table1 ORD
