Thanks dude
On Mon, Apr 18, 2011 at 2:25 PM, Chetan Suttraway <
chetan.suttra...@enterprisedb.com> wrote:
>
>
> On Fri, Apr 15, 2011 at 10:29 PM, Nick Raj wrote:
>
>> Hi,
>> Can anybody tell me how to typecast data type Point into Datum?
>>
>> Thanks
>> Nick
>>
>
> Assuming you are referring to
On Fri, Apr 15, 2011 at 10:29 PM, Nick Raj wrote:
> Hi,
> Can anybody tell me how to typecast data type Point into Datum?
>
> Thanks
> Nick
>
Assuming you are referring to c-code,
Point somepoint;
Datum result;
result = PointPGetDatum(&somepoint)
You can also checkout src/backend/utils/adt/g
Thank you Ed,
>IIRC, this is a known issue with 'IN', and that the traditional
>solution was to replace use of 'IN' with 'EXISTS', i.e.,
>
> and EXISTS (select * from userdir where user_name = username and
>towncode...)
>
>Cheers,
>Ed Loehr
>
>
>
>
John Henderson wrote:
>
> This is what I want to do:
> select user_name, date_trunc('minutes',sum(is_roundup_01(sess_time)))
> from sessions_feb2000_homer s where
> date_part('epoch',start)>'949316399' and
> date_part('epoch'
