[GENERAL] Re: Return cursor

2001-05-28 Thread Alexander Dederer
Can you send PL/SQL code and back-end code used this PL/SQL code? Myself trubles with CURSOR I resolve use LIMIT ... OFFSET ... Alla wrote: > I am porting our database from Oracle to PostgreSQL > > I know quite a lot about Oracle and pretty much nothing about > PostgreSQL :-)) > > I have a lo

[SQL] Re: Transposing data

2001-05-22 Thread Alexander Dederer
k | 40k | 50k | more --+-+-+-+-- age_1| 1 | | 2 |2 age_2| | 2 | | age_3| | 1 | | (3 rows) Alexander Dederer. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

[SQL] Re: timestamp bug

2001-05-22 Thread Alexander Dederer
Cedar Cox wrote: > > There appears to be a bug in timestamp/interval addition. It happens in > both PG version 7.0.2 and 7.1. There is a duplicate day (2001 Sep 07) and > a missing day (2002 Apr 04). I discovered this by accident when I asked > the interface I'm writing for a 365 day long cal