pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
About EXECUTE in pl/pgsql
7+ messages / 3 participants
[nested] [flat]

* About EXECUTE in pl/pgsql
@ 2002-03-25 03:42 jack <datactrl@tpg.com.au>
  2002-03-25 03:55 ` Re: About EXECUTE in pl/pgsql Bruce Momjian <pgman@candle.pha.pa.us>
  2002-03-25 07:45 ` Re: About EXECUTE in pl/pgsql Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 2 replies; 7+ messages in thread

From: jack @ 2002-03-25 03:42 UTC (permalink / raw)
  To: pgsql-sql

Hi, 
I do following in pl/pgsql. (st1 has been set to "LIKE 'abc%' ")

 EXECUTE
  ''CREATE TEMP TABLE comuser AS '' ||
  ''SELECT * FROM comt_user1 WHERE username ''||St1||
  ''ORDER BY username;'';

I've got "ERROR: EXECUTE ..SELECT INTO hasn't impletmented", How can??

JACK




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: About EXECUTE in pl/pgsql
  2002-03-25 03:42 About EXECUTE in pl/pgsql jack <datactrl@tpg.com.au>
@ 2002-03-25 03:55 ` Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 0 replies; 7+ messages in thread

From: Bruce Momjian @ 2002-03-25 03:55 UTC (permalink / raw)
  To: jack <datactrl@tpg.com.au>; +Cc: pgsql-sql

jack wrote:
> Hi, 
> I do following in pl/pgsql. (st1 has been set to "LIKE 'abc%' ")
> 
>  EXECUTE
>   ''CREATE TEMP TABLE comuser AS '' ||
>   ''SELECT * FROM comt_user1 WHERE username ''||St1||
>   ''ORDER BY username;'';
> 
> I've got "ERROR: EXECUTE ..SELECT INTO hasn't impletmented", How can??

Can you try to CREATE the table and then do a INSERT ... SELECT. 
Perhaps that's the only way.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: About EXECUTE in pl/pgsql
  2002-03-25 03:42 About EXECUTE in pl/pgsql jack <datactrl@tpg.com.au>
@ 2002-03-25 07:45 ` Tom Lane <tgl@sss.pgh.pa.us>
  2002-03-25 10:36   ` Re: About EXECUTE in pl/pgsql jack <datactrl@tpg.com.au>
  2002-03-25 20:58   ` Re: About EXECUTE in pl/pgsql Bruce Momjian <pgman@candle.pha.pa.us>
  1 sibling, 2 replies; 7+ messages in thread

From: Tom Lane @ 2002-03-25 07:45 UTC (permalink / raw)
  To: jack <datactrl@tpg.com.au>; +Cc: pgsql-sql

"jack" <datactrl@tpg.com.au> writes:
> I do following in pl/pgsql. (st1 has been set to "LIKE 'abc%' ")

>  EXECUTE
>   ''CREATE TEMP TABLE comuser AS '' ||
>   ''SELECT * FROM comt_user1 WHERE username ''||St1||
>   ''ORDER BY username;'';

> I've got "ERROR: EXECUTE ..SELECT INTO hasn't impletmented", How can??

Ooops :-(.  That check was intended to prevent SELECT ... INTO table
from being used in EXECUTE, mainly because of the confusion factor
(SELECT INTO in plpgsql doesn't mean what it means in SQL, but the
SQL interpretation is what you'd get from EXECUTE).

However, the check wasn't intended to trigger on CREATE AS.

I've stuck a quick fix into the current sources.  Should be in 7.2.1.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: About EXECUTE in pl/pgsql
  2002-03-25 03:42 About EXECUTE in pl/pgsql jack <datactrl@tpg.com.au>
  2002-03-25 07:45 ` Re: About EXECUTE in pl/pgsql Tom Lane <tgl@sss.pgh.pa.us>
@ 2002-03-25 10:36   ` jack <datactrl@tpg.com.au>
  1 sibling, 0 replies; 7+ messages in thread

From: jack @ 2002-03-25 10:36 UTC (permalink / raw)
  To: pgsql-sql

Thank you Tom
----- Original Message ----- 
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "jack" <datactrl@tpg.com.au>
Cc: <pgsql-sql@postgresql.org>
Sent: Monday, March 25, 2002 5:45 PM
Subject: Re: [SQL] About EXECUTE in pl/pgsql 


> "jack" <datactrl@tpg.com.au> writes:
> > I do following in pl/pgsql. (st1 has been set to "LIKE 'abc%' ")
> 
> >  EXECUTE
> >   ''CREATE TEMP TABLE comuser AS '' ||
> >   ''SELECT * FROM comt_user1 WHERE username ''||St1||
> >   ''ORDER BY username;'';
> 
> > I've got "ERROR: EXECUTE ..SELECT INTO hasn't impletmented", How can??
> 
> Ooops :-(.  That check was intended to prevent SELECT ... INTO table
> from being used in EXECUTE, mainly because of the confusion factor
> (SELECT INTO in plpgsql doesn't mean what it means in SQL, but the
> SQL interpretation is what you'd get from EXECUTE).
> 
> However, the check wasn't intended to trigger on CREATE AS.
> 
> I've stuck a quick fix into the current sources.  Should be in 7.2.1.
> 
> regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
> 




^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: About EXECUTE in pl/pgsql
  2002-03-25 03:42 About EXECUTE in pl/pgsql jack <datactrl@tpg.com.au>
  2002-03-25 07:45 ` Re: About EXECUTE in pl/pgsql Tom Lane <tgl@sss.pgh.pa.us>
@ 2002-03-25 20:58   ` Bruce Momjian <pgman@candle.pha.pa.us>
  2002-03-25 21:03     ` Re: About EXECUTE in pl/pgsql Tom Lane <tgl@sss.pgh.pa.us>
  1 sibling, 1 reply; 7+ messages in thread

From: Bruce Momjian @ 2002-03-25 20:58 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: jack <datactrl@tpg.com.au>; pgsql-sql

Tom Lane wrote:
> "jack" <datactrl@tpg.com.au> writes:
> > I do following in pl/pgsql. (st1 has been set to "LIKE 'abc%' ")
> 
> >  EXECUTE
> >   ''CREATE TEMP TABLE comuser AS '' ||
> >   ''SELECT * FROM comt_user1 WHERE username ''||St1||
> >   ''ORDER BY username;'';
> 
> > I've got "ERROR: EXECUTE ..SELECT INTO hasn't impletmented", How can??
> 
> Ooops :-(.  That check was intended to prevent SELECT ... INTO table
> from being used in EXECUTE, mainly because of the confusion factor
> (SELECT INTO in plpgsql doesn't mean what it means in SQL, but the
> SQL interpretation is what you'd get from EXECUTE).
> 
> However, the check wasn't intended to trigger on CREATE AS.
> 
> I've stuck a quick fix into the current sources.  Should be in 7.2.1.

CVS current and 7.2.X CVS HISTORY/release.sgml updated with:

 Allow CREATE TABLE AS ... SELECT in PL/PgSQL (Tom)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: About EXECUTE in pl/pgsql
  2002-03-25 03:42 About EXECUTE in pl/pgsql jack <datactrl@tpg.com.au>
  2002-03-25 07:45 ` Re: About EXECUTE in pl/pgsql Tom Lane <tgl@sss.pgh.pa.us>
  2002-03-25 20:58   ` Re: About EXECUTE in pl/pgsql Bruce Momjian <pgman@candle.pha.pa.us>
@ 2002-03-25 21:03     ` Tom Lane <tgl@sss.pgh.pa.us>
  2002-03-25 21:23       ` Re: About EXECUTE in pl/pgsql Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 1 reply; 7+ messages in thread

From: Tom Lane @ 2002-03-25 21:03 UTC (permalink / raw)
  To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: jack <datactrl@tpg.com.au>; pgsql-sql

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> CVS current and 7.2.X CVS HISTORY/release.sgml updated with:
>  Allow CREATE TABLE AS ... SELECT in PL/PgSQL (Tom)

We already did allow that.  Please make it say

  Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom)

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 7+ messages in thread

* Re: About EXECUTE in pl/pgsql
  2002-03-25 03:42 About EXECUTE in pl/pgsql jack <datactrl@tpg.com.au>
  2002-03-25 07:45 ` Re: About EXECUTE in pl/pgsql Tom Lane <tgl@sss.pgh.pa.us>
  2002-03-25 20:58   ` Re: About EXECUTE in pl/pgsql Bruce Momjian <pgman@candle.pha.pa.us>
  2002-03-25 21:03     ` Re: About EXECUTE in pl/pgsql Tom Lane <tgl@sss.pgh.pa.us>
@ 2002-03-25 21:23       ` Bruce Momjian <pgman@candle.pha.pa.us>
  0 siblings, 0 replies; 7+ messages in thread

From: Bruce Momjian @ 2002-03-25 21:23 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: jack <datactrl@tpg.com.au>; pgsql-sql

Tom Lane wrote:
> Bruce Momjian <pgman@candle.pha.pa.us> writes:
> > CVS current and 7.2.X CVS HISTORY/release.sgml updated with:
> >  Allow CREATE TABLE AS ... SELECT in PL/PgSQL (Tom)
> 
> We already did allow that.  Please make it say
> 
>   Allow EXECUTE of "CREATE TABLE AS ... SELECT" in PL/PgSQL (Tom)

Done.  I was wondering if EXECUTE was the only issue.  I see it was.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026



^ permalink  raw  reply  [nested|flat] 7+ messages in thread


end of thread, other threads:[~2002-03-25 21:23 UTC | newest]

Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-25 03:42 About EXECUTE in pl/pgsql jack <datactrl@tpg.com.au>
2002-03-25 03:55 ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-25 07:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2002-03-25 10:36   ` jack <datactrl@tpg.com.au>
2002-03-25 20:58   ` Bruce Momjian <pgman@candle.pha.pa.us>
2002-03-25 21:03     ` Tom Lane <tgl@sss.pgh.pa.us>
2002-03-25 21:23       ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox