RE:

From: "Ansley, Michael" <Michael(dot)Ansley(at)intec(dot)co(dot)za>
To: "'David Gilbert'" <dgilbert(at)velocet(dot)ca>, pgsql-hackers(at)postgreSQL(dot)org
Subject: RE:
Date: 1999-09-30 13:23:26
Message-ID: 1BF7C7482189D211B03F00805F8527F748C0EA@S-NATH-EXCH2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)velocet(dot)ca]
>> Sent: Thursday, September 30, 1999 3:17 PM
>> To: pgsql-hackers(at)postgreSQL(dot)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(at)velocet(dot)net | equal if
>> and only if they |
>> |http://www.velocet.net/~dgilbert | are
>> precisely opposite. |
>> =========================================================GLO=
>> ===============
>>
>> ************
>>

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-09-30 13:25:04 Re: [HACKERS] Regression tests on intel for 6.5.2
Previous Message David Gilbert 1999-09-30 13:17:25