Re: [GENERAL] Typecast

2011-04-18 Thread Chetan Suttraway
On Fri, Apr 15, 2011 at 10:29 PM, Nick Raj nickrajj...@gmail.com 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

Re: [GENERAL] Typecast

2011-04-18 Thread Nick Raj
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 nickrajj...@gmail.com wrote: Hi, Can anybody tell me how to typecast data type Point into Datum? Thanks Nick Assuming you are referring

[GENERAL] Typecast

2011-04-15 Thread Nick Raj
Hi, Can anybody tell me how to typecast data type Point into Datum? Thanks Nick

[GENERAL] TypeCast: util.list to array type

2010-02-22 Thread beulah prasanthi
Helo I am working on spring project with postgres 8.4 i wrote a function in postgrees which i am passing the argument email email[] array From front end we need to insesrt data into that emailarray .so i used java.arraylist.util while i am running i got the following error Please help me

Re: [GENERAL] typecast for index

2000-02-14 Thread John Henderson
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

[GENERAL] typecast for index

2000-02-13 Thread John Henderson
Hi y'all, 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',start)'951822000' and

Re: [GENERAL] typecast for index

2000-02-13 Thread 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