Re: Create table doesn't work in plpgsql - Mailing list pgsql-sql

From Jie Liang
Subject Re: Create table doesn't work in plpgsql
Date
Msg-id Pine.BSF.4.10.10012211016060.56837-100000@tidal.ipinc.com
Whole thread Raw
In response to Re: Create table doesn't work in plpgsql  (Volker Paul <vpaul@dohle.com>)
List pgsql-sql
Hi,there,

I am not quite sure what you try to do.
However, plpgsql allows you use any DDL, most of functions defined and
sql operators.
I don't see the problem.

Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com

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?
> 
> 
> Volker Paul
> 



pgsql-sql by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Invoice number
Next
From: Najm Hashmi
Date:
Subject: pg_dump Error