From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | Volker Paul <vpaul(at)dohle(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Create table doesn't work in plpgsql |
Date: | 2000-12-21 17:10:21 |
Message-ID: | Pine.BSF.4.21.0012210908570.86012-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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.
> Thanks, but that leaves me with a problem.
> What I really want to do is something like
> select str from person where id=1234;
> where str is a string that contains an expression like
> famname || ', ' || givname
> i.e. the final select is
> select famname || ', ' || givname from person where id=1234;
> I know it's possible by building the select e.g. in bash
> and calling psql with it as an argument, but do you see a possibility
> that is closer to Postgres, e.g. in plpgsql?
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Elphick | 2000-12-21 17:50:43 | Re: Invoice number |
Previous Message | Stephan Szabo | 2000-12-21 17:08:49 | Re: Invoice number |