INSERT INTO FROM SELECT

From: "lmanorders" <lmanorders(at)gmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: INSERT INTO FROM SELECT
Date: 2014-06-02 23:52:02
Message-ID: 3E1F14476E8F460B852321F7368DBBF0@LynnPC
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andrej 2014-06-03 00:00:49 Re: INSERT INTO FROM SELECT
Previous Message David G Johnston 2014-05-29 14:03:39 Re: prevent duplicate entries