long postgresql string

[Dr Eberhard W Lisse]

Hi,

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:


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".



"SELECT ip, clid, date(created) AS eppdate, request from EPP_LOG"

also works but then I get tons of XML into request.


Is there a way to RECODE the content of the variable?

greetings, el
-- 
Dr. Eberhard W. Lisse  \        /      Obstetrician & Gynaecologist
address@hidden            / *     | Telephone: +264 81 124 6733 (cell)
PO Box 8421             \     / Please do NOT email to this address
Bachbrecht, Namibia     ;____/      if it is DNS related in ANY way