Re: SQL For smarties

From: "Graham Vickrage" <graham(at)digitalplanit(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: SQL For smarties
Date: 2002-02-20 18:55:51
Message-ID: NDBBJABDILOPAOOMFJHOGEAMDEAA.graham@digitalplanit.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I am trying to create tables from within a funtion i.e.

create function _tree_create(text) retuns int as '
begin;
create table $1_tree (....);
return 1;
end;
...

select _tree_create('item');

An error message refering to $1 gets thrown up. Is this not possible to do
or is there another way of doing it?

Thanks in advance.

Graham

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2002-02-20 19:15:51 Re: SQL For smarties
Previous Message clayton cottingham 2002-02-20 17:28:51 Re: comparision chart