Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Using order by in a view
- Thread starter rewob65
- Start date
What version of PSQL are you using?
What's the exact error being returned?
How are you creating the view (what's the actual SQL statement)?
The following works for me using PSQL v10.10:
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
What's the exact error being returned?
How are you creating the view (what's the actual SQL statement)?
The following works for me using PSQL v10.10:
Code:
create view view1 as select * from class order by name#
select * from view1Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
- Thread starter
- #3
Version 9.00.066.000
The View is :-
CREATE VIEW ME AS
SELECT "SUND__B6Price_Table"."PTABPrice_Table_No", "SUND__B6Price_Table"."DESCDescription"
FROM "SUND__B6Price_Table" "SUND__B6Price_Table"
ORDER BY "SUND__B6Price_Table"."PTABPrice_Table_No
and the error shows first a load of text about links then:-
order<<???>> By "SUND__B6Price_Table"
This is just a simple report but seems to dislike the order function. I have read the order can be in the select area but I do not understand the syntax
The View is :-
CREATE VIEW ME AS
SELECT "SUND__B6Price_Table"."PTABPrice_Table_No", "SUND__B6Price_Table"."DESCDescription"
FROM "SUND__B6Price_Table" "SUND__B6Price_Table"
ORDER BY "SUND__B6Price_Table"."PTABPrice_Table_No
and the error shows first a load of text about links then:-
order<<???>> By "SUND__B6Price_Table"
This is just a simple report but seems to dislike the order function. I have read the order can be in the select area but I do not understand the syntax
According to the documentation ( Views cannot contain ORDER BY clauses in PSQL v9.x. They are supported in v10.x. You should be able to add the ORDER BY when running the view:
select * from ME order by "SUND__B6Price_Table"
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
select * from ME order by "SUND__B6Price_Table"
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
- Status
Similar threads
- Locked
- Question
- Locked
- Question