Re: long postgresql string

[Ben Pfaff]

Dr Eberhard W Lisse <address@hidden> writes:

> I have managed to compile PSPP with PostgreSQL support on Ubuntu 10.04
> the standard version came without it and can run simple queries, however
> when I run something like the below (shortened) it wants the whole SQL
> statement in one line, and that line must be less than 255 characters,
> which defeats the purpose:

You can use + to concatenate parts of a string and split strings
across lines, as in:

 GET DATA /TYPE=PSQL
     /CONNECT='host=localhost port=5432 dbname=epp '
     /SQL="SELECT ip, clid, date(created) AS eppdate, " +
           "CASE WHEN request ILIKE '%poll op=%'  THEN 'poll' " +
                "WHEN request ILIKE '%<login%' THEN 'login' " + 
                "WHEN request ILIKE '%<logout%' THEN 'logout' " +
            "ELSE 'other' " +
            "END AS epprequest " +
        "FROM epp_log".

I can't think of a good reason for the 255-character limit.  I
think it must be a relic from before PSPP added support for long
string values.  I've pushed out a change that removes this
restriction to the "master" branch.
-- 
"Writing is easy.
 All you do is sit in front of a typewriter and open a vein."
--Walter Smith