[GENERAL] hi, what is wrong with my newbie sql?

2006-09-27 Thread Ronin
Hi, the following sql returns "10" and not "20" as would be expected. Where is the error? This would for sure work in any programming language, why is this different? CREATE FUNCTION test () RETURNS INTEGER AS ' DECLARE k integer; BEGIN k = 10;

[GENERAL] pgsql bug found?

2006-12-04 Thread Ronin
Hi when I do the following function it fills 2 dates per day from 1970 to 2050, except that some months (typical 2 months per year) have 4 dates for one day. this is totally freaky.. I wonder if postgresql is tripping over itself making a double entry every now and again. for instance I constantl

Re: [GENERAL] pgsql bug found?

2006-12-05 Thread Ronin
sweet that worked! thanks Michael Glaesemann wrote: > On Dec 4, 2006, at 23:52 , Ronin wrote: > > > Hi when I do the following function it fills 2 dates per day from 1970 > > to 2050, except that some months (typical 2 months per year) have 4 > > dates for one day. th