Tino Wildenhain <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> You're not seriously suggesting we reimplement evaluation of WHERE clauses
>> on the client side, are you?
> no, did I? But what is wrong with something like:
> \COPY 'SELECT foo,bar,baz FROM footable WHERE baz=5 ORDER BY foo' TO
> file|stdout
> which would just run the query (in the backend of course) and
> format the output just like copy would...
Oh, I see what you have in mind. But that's hardly free either. It
requires psql to be able to translate between the frontend SELECT data
format and COPY format; which is far from a trivial thing, especially
when you consider all those CSV options ;-). And then we get to
maintain that code in parallel with the backend code anytime someone
wants another COPY feature. And then if you want the feature in a
different client, you get to do it all over again.
On balance I think doing it in the backend is more flexible and requires
less duplication of code.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
