I believe (although I haven't tried it) that pltcl will allow
you to do things such as this.
On Thu, 21 Dec 2000, Volker Paul wrote:
> Hi,
>
> > I don't think you can use DDL(data definition language) in PL/SQL.
> > create table is not DML(data munipulation language) instead
> > it's a DDL.
>
> I'm wondering how people creates guaranteed sequential numbers - in my case
> for invoice numbers.
>
> - Sequences are not rollback'able.
> - It seems overkill to have a table just for this.
> - What else?
You'll probably need a table (although you may be able to get away with
only one for a
I believe a couple of months back... a EXECUTE command was added to plpgsql
to allow users to dynamic sql statements.
So if you get the current development version you should be able to call
EXECUTE CREATE TABLE
or whatever sql you like. (I think this is still not in 7.03, not sure though
Well, this message never made it through, but I managed to answer my own
question -- I never ran vacuum analyze which caused a table scan instead of
an index scan. After running vacuum analyze the query returns immediately. I
would still be interested in any hints to optimize performance for very
