Re: long postgresql string

[Dr Eberhard W Lisse]

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 <address@hidden> 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
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