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
