Postgresql syntax error at or near "("

Question

I trying to write some condition to pull out objects from database:

Page.where(published: true).where("`published_at` <= current_date()").where("`publication_end` IS NULL OR `publication_end` > current_date()")

When i enter it in the rails console i have the following error:

 SELECT "pages".* FROM "pages" WHERE "pages"."published" = 't' AND (`published_at` <= current_date()) AND (`publication_end` IS NULL OR `publication_end` > current_date())
PG::SyntaxError: ERROR:  syntax error at or near "("
LINE 1: ...blished" = 't' AND (`published_at` <= current_date()) AND (`...
                                                             ^
: SELECT "pages".* FROM "pages"  WHERE "pages"."published" = 't' AND (`published_at` <= current_date()) AND (`publication_end` IS NULL OR `publication_end` > current_date())
ActiveRecord::StatementInvalid: PG::SyntaxError: ERROR:  syntax error at or near "("
LINE 1: ...blished" = 't' AND (`published_at` <= current_date()) AND (`...
                                                             ^
: SELECT "pages".* FROM "pages"  WHERE "pages"."published" = 't' AND (`published_at` <= current_date()) AND (`publication_end` IS NULL OR `publication_end` > current_date())

I,m Using Postgresql Please help.

current_date does not have the trailing "()", though "now()" does. — bma
– bma, Commented Feb 19, 2014 at 15:55
I hope those backticks are part of the ActiveRecord's syntax and not something that's sent to Postgres. — Milen A. Radev
– Milen A. Radev, Commented Feb 19, 2014 at 16:00

Dylan Markow · Accepted Answer · 2014-02-19 15:55:31Z

2

Remove the parentheses:

# select current_date();
ERROR:  syntax error at or near "("
LINE 1: select current_date();  

# select current_date;
    date
------------
 2014-02-19
(1 row)

answered Feb 19, 2014 at 15:55

Dylan Markow

125k27 gold badges287 silver badges202 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Craig Ringer Over a year ago

By way of explanation: current_date is a special SQL keyword specified in the ANSI SQL standard. It acts like a function that takes zero arguments, but unlike a function its syntax doesn't require or allow parentheses. Yet another example of the SQL standards committee making up weird syntax for fun.

Mateusz Urbański · Accepted Answer · 2014-02-19 16:02:09Z

-1

i write:

Page.where(published: true).where("published_at <= current_date").where("publication_end IS NULL OR publication_end > current_date")

and now i ok

Thanks :)

answered Feb 19, 2014 at 16:02

Mateusz Urbański

7,99216 gold badges75 silver badges142 bronze badges

Collectives™ on Stack Overflow

Postgresql syntax error at or near "("

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related