Postgres problem

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