Re: [BUGS] interval conversion bug

2004-11-25 Thread Stephan Szabo
On Thu, 25 Nov 2004, Andrzej Wojtaszek wrote: > I'm afraid that operator ::interval not working propertly > example: > > select 1 > ## > select now() + (1||' day')::interval; > working propertly > ## This is a text -> interval conversion > select 3 > #

Re: [BUGS] interval conversion bug

2004-11-25 Thread Tom Lane
"Andrzej Wojtaszek" <[EMAIL PROTECTED]> writes: > not working with error "cannot cast type character varying to iterval" 8.0 is more flexible about that, but for the moment use type text instead of varchar. regards, tom lane ---(end of broadcast)--

[BUGS] interval conversion bug

2004-11-25 Thread Andrzej Wojtaszek
Hi, I'm afraid that operator ::interval not working propertly example: select 1 ## select now() + (1||' day')::interval; working propertly ## I have my function writen in plpgsql function test(varchar) returns varchar; select 2 ##

[BUGS] Installation fails for postgresql-8.0.0-beta4 on WindowsXP SP1

2004-11-25 Thread Mehul Doshi-A20614
Hi, I am trying to install the 8.0 beta4 version for Windows onto my system and facing an error which I can't fix. System: Windows XP, Sevice Pack 1 I am an admin on my system, but a regular user on a domain. I have created a non-admin user named "postgres" which is a member of the "Users" gr