Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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=
>> ===============
>> 
>> ************
>> 

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group