[Top][All Lists]

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

Re: long postgresql string

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


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: ILIKE '%<hello%' THEN 'hello'   WHEN request

I'll try to figure out how to pull the updated source from the master
but appreciate advice how to do that too :-)-O


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:
>      /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

reply via email to

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