Re: greetings

Ken Kline <ken@oldbs.com> writes:
> orginally what I wanted to do was this:

> INSERT INTO pledge_classes (semester, year)
> SELECT distinct pseason, pyear from load_bros
> WHERE  pyear is not null
> AND    pseason is not null
> order by pyear, pseason;

> however pgsql does not allow order by in an INSERT-SELECT statement

Three answers for the price of one ;-) :

1. Why are you trying to constrain the order in an INSERT in the first
place?  Tuple order in a table is meaningless under SQL semantics.

2. If you really feel you have to have that, you could rely on the
sorting done implicitly by DISTINCT:
INSERT INTO pledge_classes (year, semester)SELECT distinct pyear, pseason from load_brosWHERE  pyear is not nullAND
pseasonis not null;
 

3. 7.1 will allow you to use an ORDER BY here, pointless though it is.
        regards, tom lane