What is the maximum query length in postgresql?

[osman7king]

If I want to generate dynamically some queries in a php 5 application to retrieve information from an postgresql database. is there a maximum length for this query?

When i use the IN statement, how many values can I use in?

[rski]

I don't think there is a query length limit, I did't hear about it. Did you meet any problems with such 'big' IN statement

[osman7king]

In Oracle database the maximum size of SQL statement is
about 4000 characters, I want to know what about PostgreSQL
(of course it more more than 4000 characters, but is there any
number for the max size of a query?

thanks a lot.

[rski]

In postgres source code there are lots of statements where query text (sourceText) is defined as 'const char *', see below

static void
ProcessQuery(PlannedStmt *plan,
              const char *sourceText,
              ParamListInfo params,
              DestReceiver *dest,
              char *completionTag)

So I assume that max query lenght is not 'hard coded'