Skip site navigation (1) Skip section navigation (2)

Re: plpgsql function question

From: Scott Geller <sgellergsu(at)gmail(dot)com>
To: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: plpgsql function question
Date: 2010-04-04 14:27:41
Message-ID: u2kc598163c1004040727r23c1d19dm379538b89575b170@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Andreas

Thanks for the response... it seems to be working now - I hate it when that
happens



On Sun, Apr 4, 2010 at 1:29 AM, Andreas Kretschmer <
akretschmer(at)spamfence(dot)net> wrote:

> Scott Geller <sgellergsu(at)gmail(dot)com> wrote:
>
> >
> > Hi
> >
> > I am learning plpgsql and am getting errors on this simple function:
> >
> > CREATE OR REPLACE FUNCTION test2(tab1 text, tab2 text )
> >   RETURNS text AS
> >   $$
> >   BEGIN
> >   EXECUTE 'create table ' || quote_ident(tab2) || ' as Select *  from '
> ||
> > quote_ident(tab1);
> >     RETURN 'done';
> >   END; $$
> >   LANGUAGE 'plpgsql' VOLATILE;
>
> Works for me, without errors:
>
> test=# create table tab1(i int);
> CREATE TABLE
> Zeit: 0,850 ms
> test=*# CREATE OR REPLACE FUNCTION test2(tab1 text, tab2 text )
>   RETURNS text AS
>  $$
>  BEGIN
>  EXECUTE 'create table ' || quote_ident(tab2) || ' as Select *  from ' ||
> quote_ident(tab1);
>    RETURN 'done';
>  END; $$
>  LANGUAGE 'plpgsql' VOLATILE;
> CREATE FUNCTION
> Zeit: 0,472 ms
> test=*# select * from test2('tab1','tab2');
>  test2
> -------
>  done
> (1 Zeile)
>
> Zeit: 1,844 ms
>
>
> Please show the error you got.
>
>
>
> Andreas
> --
> Really, I'm not out to destroy Microsoft. That will just be a completely
> unintentional side effect.                              (Linus Torvalds)
> "If I was god, I would recompile penguin with --enable-fly."   (unknown)
> Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>

In response to

pgsql-novice by date

Next:From: Carel CombrinkDate: 2010-04-06 08:57:46
Subject: C-Language Functions: VarChar and Text arguments
Previous:From: Andreas KretschmerDate: 2010-04-04 07:29:03
Subject: Re: plpgsql function question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group