Re: INSERT INTO FROM SELECT

Hi Lynn,

To the best of my knowledge the SQL standard doesn't define that data
inside a table needs
to be stored in any given order. If you expect to see it in a certain
sequence define that at query time,
when you retrieve the data?

Cheers,
Andrej

On 3 June 2014 11:52, lmanorders <lmanorders(at)gmail(dot)com> wrote:
> I’m using Postgres 9.3 on Windows. I am attempting to insert several rows
> into a table using data from another table. It is inserting correctly, but
> the order isn’t correct. Is an ‘order by’ command not recognized in this
> situation?
>
> Here are the two tables:
> CREATE TABLE accounts (
> acctno char(22) PRIMARY KEY,
> acctdesc varchar(60),
> ...
> accttype integer
> );
>
> CREATE TABLE rprtfrmt (
> lineno integer PRIMAY KEY,
> bdgtacct char(22),
> prntline integer,
> addline integer,
> totllevl integer,
> desconly integer,
> prntundrln integer,
> balshtentry integer,
> rprttype integer,
> blnkline integer
> );
>
> Here are the commands I’m using:
>
> CREATE TEMP SEQUENCE rprtfrmt_seq INCREMENT BY 50 START WITH 50;
> INSERT INTO rprtfrmt (lineno, bdgtacct, prntline, addline, totllevl,
> desconly, prntunderln, balshtentry, rprttype, blnkline)
> (SELECT nextval(‘rprtfrmt_seq’), acctno, 1,1,0,0,0,0,0,1 FROM accounts
> WHERE (accttype = 0 OR accttype = 2) ORDER BY acctno)
>
> It inserts all of the line numbers, account numbers, and ‘fixed’ data into
> the rprtfrmt table, but not in account number order. Any help will be
> greatly appreciated.
> Thanks,
> Lynn
>

--
Please don't top post, and don't use HTML e-Mail :} Make your quotes concise.

http://www.georgedillon.com/web/html_email_is_evil.shtml