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
e...@lisse.na / * | 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
_______________________________________________
Pspp-users mailing list
Pspp-users@gnu.org
http://lists.gnu.org/mailman/listinfo/pspp-users
