Re: [HACKERS] cant execute yyparse() within postgresql
Sibtay Abbas wrote: i never happen to read this rule when i signed up to this mailing list...so if you ve made up a rule by urself for this mailing list just do us a favor by officially announcing it Got a question ...? http://www.catb.org/~esr/faqs/smart-questions.html Andre ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] plans for bitmap indexes?
Hannu Krosing wrote: the per-page clustering would make sure that all the tuples would be on 1 (or on a few) pages. I understand that You can cluster on one column, but how do you do it for indexes on other columns? BTW, lossy variants also lose count(), group by only from index and what comes to updating the index, you have to do it only once per 100 pages ;) Sorry, how does that work, if I update foo = 'bar'-'baz' - I can flip the 'baz' bit on right away but I have to check every other row to see if I can turn the 'bar' bit off Andre ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [HACKERS] Anybody have an Oracle PL/SQL reference at hand?
Title: RE: [HACKERS] Anybody have an Oracle PL/SQL reference at hand? Tom Lane wrote: Hmm. Not only is that a pretty short list, but many of them don't correspond very closely to the errors that Postgres would raise. I think these where like predefined 'shortcuts' for most common exceptions/errors. You can declare exceptions for any oracle error number smth. like PRAGMA EXCEPTION_INIT(rollback_too_small, -1555) PL/SQL allows users to define and raise their own exceptions too. Yeah. Our RAISE statement really needs a lot of work, but I think it will have to be left for a future release cycle ... Sorry, if the following doesn't make sense, I started exploring just a week ago... >From reading the docs I could't determine what would be the exception to catch in the outer block for e.g. RAISE NOTICE 'caught division_by_zero'; and how to raise the same exeption again, for example if I determine that the exception still cannot be handled correcly in WHEN OTHERS section. Does RAISE raise the same exception or can I specify the type somehow? Andre