[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:1.9.1.11pre) Gecko/20100507 Shredder/3.0.5pre |
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
- long postgresql string,
Dr Eberhard W Lisse <=