[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

long postgresql string

From: Dr Eberhard W Lisse
Subject: long postgresql string
Date: Sat, 29 May 2010 00:40:46 +0100
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv: Gecko/20100507 Shredder/3.0.5pre


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:

    /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

reply via email to

[Prev in Thread] Current Thread [Next in Thread]