Received: from smtp.networkusa.net (smtp.networkusa.net [216.15.144.12]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBLFtE616247 for ; Thu, 21 Dec 2000 10:55:14 -0500 (EST) (envelope-from dalgoda@ix.netcom.com) Received: from ylum.mrc-home.org (109-62.bestdsl.net [216.162.109.62]) by smtp.networkusa.net (8.8.7/8.8.7) with ESMTP id KAA19581 for ; Thu, 21 Dec 2000 10:47:24 -0600 Received: from thune.mrc-home.org by ylum.mrc-home.org (8.10.0) id K1OFscH24539; Sun, 24 Feb 1980 09:54:38 -0600 Received: by thune.mrc-home.org (8.10.0) id eBLFsuT05124; Thu, 21 Dec 2000 09:54:56 -0600 Date: Thu, 21 Dec 2000 09:54:56 -0600 From: Mike Castle To: pgsql-sql@postgresql.org Subject: Re: Create table doesn't work in plpgsql Message-ID: <20001221095456.C5037@thune.mrc-home.org> Reply-To: Mike Castle Mail-Followup-To: Mike Castle , pgsql-sql@postgresql.org References: <3A41E0BA.FBEDF52F@dohle.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.6i In-Reply-To: <3A41E0BA.FBEDF52F@dohle.com>; from vpaul@dohle.com on Thu, Dec 21, 2000 at 11:51:38AM +0100 X-Archive-Number: 200012/250 X-Sequence-Number: 587 On Thu, Dec 21, 2000 at 11:51:38AM +0100, Volker Paul wrote: > 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? Can this be done using tcl or perl? mrc -- Mike Castle Life is like a clock: You can work constantly dalgoda@ix.netcom.com and be right all the time, or not work at all www.netcom.com/~dalgoda/ and be right at least twice a day. -- mrc We are all of us living in the shadow of Manhattan. -- Watchmen