Because default is an SQL keyword. You need to provide a column name (or rather an expression) and optionally either ASC or DESC.
Michael
Because default is an SQL keyword. You need to provide a column name (or rather an expression) and optionally either ASC or DESC.
Michael
Michael Schuerig wrote: >> -------------- >> >> Why? > > Because default is an SQL keyword. You need to provide a column > name (or rather an expression) and optionally either ASC or DESC.
But I do not have a column called "default". I do not understand where the word "default" comes from in the query.
To give us a chance of solving your problem you'll have to show us the code that results in this query being executed
PGError: ERROR: syntax error at or near "default" RAD 1: SELECT * FROM ivr_menus ORDER BY default LIMIT 20 OFFSET 0 ^
: SELECT * FROM ivr_menus ORDER BY default LIMIT 20 OFFSET 0
Michael