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 wrote: > >> Hi, >> Can anybody tell me how to typecast data type Point into Datum? >> >> Thanks >> Nick >> > > Assuming you are referring to

Re: [GENERAL] Typecast

2011-04-18 Thread Chetan Suttraway
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

[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 err

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 > > > >

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 > date_part('epoch'

[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