Use the stuff that just got sent for Access (Interfaces list, header ->
"ODBC-client->Linux-server: datatype boolean not recognized?"). Same
principle.
MikeA
>> -----Original Message-----
>> From: David Gilbert [mailto:dgilbert@velocet.ca]
>> Sent: Thursday, September 30, 1999 3:17 PM
>> To: pgsql-hackers@postgreSQL.org
>> Subject:
>>
>>
>>
>> OK... doing some serious report hacking... and I decided I wanted to
>> do this:
>>
>> select acct_id,
>> sum(case when recd > ('now'::date - '30 days'::timespan)::date
>> then amt else 0) as current
>> from payable where not paid_p group by acct_id order by acct_id;
>>
>> but pgsql gives me:
>>
>> ERROR: parser: parse error at or near ")"
>>
>> Now... I also thought I might be able to contruct
>> sum(amt * <boolean>), but this also isn't allowed. I think that we
>> should make an int(boolean) function.
>>
>> Dave.
>>
>> --
>> =============================================================
>> ===============
>> |David Gilbert, Velocet Communications. | Two things
>> can only be |
>> |Mail: dgilbert@velocet.net | equal if
>> and only if they |
>> |http://www.velocet.net/~dgilbert | are
>> precisely opposite. |
>> =========================================================GLO=
>> ===============
>>
>> ************
>>