Re: max length of sql select statement ?

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: markus brosch <brosch(at)gmx(dot)de>
Cc: mallah(at)trade-india(dot)com, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: max length of sql select statement ?
Date: 2003-07-07 16:20:53
Message-ID: 1057594852.46100.11.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> Could be a solution?!
> The question is - how long could the IN be?

I'm not sure about IN specifically, but I know you can do:

SELECT * FROM table WHERE col = '<1GB long file>';

It tends not to be friendly for Ram though :)

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2003-07-07 16:23:39 Re: max length of sql select statement ?
Previous Message markus brosch 2003-07-07 16:20:20 Re: max length of sql select statement ?