golang syntax error at or near "$1" in postgres

Question

I am trying to execute a query in go using the sql module.

var from string = "2015-03-01 00:00:00"    
rows, err := db.Query("select time, val from table where " +
                              "time >= extract(epoch from timestamp with time zone $1)::int4 " +
                              "and time < extract(epoch from timestamp with time zone '2015-03-01 00:15:10')::int4 " +
                              "order by time asc",from)

However I get the error

pq: syntax error at or near "$1"

If I put in the epoch values directly then the query will work and the query works when I try it without any variables i.e. with the query hardcoded. So what is the problem?

It gives the same error (i.e. syntax error at or near "?"). Anyway, I thought that the pq module used $1 ? — robochat
– robochat, Commented Mar 12, 2015 at 12:02
hmmm... can you try and make your query a single multi-line string using backticks? Not that I think it would matter but otherwise things seem okay, and it's a better practice in terms of GC pressure and cpu performance anyway. — Not_a_Golfer
– Not_a_Golfer, Commented Mar 12, 2015 at 12:13

Tino · Accepted Answer · 2015-03-12 13:34:55Z

13

You're right about $1 and ?.

The reason why it complains about invalid syntax with $1 is because of type cast. Put it like this:

rows, err := db.Query("select time, val from table where " +
                          "time >= extract(epoch from $1::timestamp with time zone)::int4 " +
                          "and time < extract(epoch from timestamp with time zone '2015-03-01 00:15:10')::int4 " +
                          "order by time asc",from)

answered Mar 12, 2015 at 13:34

Tino

4464 silver badges6 bronze badges

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

3 Comments

Pallav Jha Over a year ago

@Tino when you say "You're right about $1 and ?.", what do you mean by it?

Pallav Jha Over a year ago

I'm stuck with the same problem.

eyoeldefare Over a year ago

@Obi Wan - PallavJha you have to specify its type

Collectives™ on Stack Overflow

golang syntax error at or near "$1" in postgres

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related