Ben,
this does not work when I introduce a few more WHEN clauses
with the error message
eppnew.sps:22: error: GET DATA: String exceeds 255 characters in length
(979 characters).
error: Error from psql source: ERROR: unterminated quoted string at or
near "'%<"
LINE 1: ...quest ILIKE '%<hello%' THEN 'hello' WHEN request
ILIKE '%<
I'll try to figure out how to pull the updated source from the master
but appreciate advice how to do that too :-)-O
el
On 05/29/2010 04:36 AM, Ben Pfaff wrote:
> Dr Eberhard W Lisse <e...@lisse.na> writes:
[...]
> 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.
--
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
