Postgres problem

rubyonrails-talk
1

Because default is an SQL keyword. You need to provide a column name (or rather an expression) and optionally either ASC or DESC.

Michael

2

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