pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedAbout 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>
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:55 Bruce Momjian <pgman@candle.pha.pa.us>
parent: jack <datactrl@tpg.com.au>
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 07:45 Tom Lane <tgl@sss.pgh.pa.us>
parent: jack <datactrl@tpg.com.au>
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 10:36 jack <datactrl@tpg.com.au>
parent: Tom Lane <tgl@sss.pgh.pa.us>
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 20:58 Bruce Momjian <pgman@candle.pha.pa.us>
parent: 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 21:03 Tom Lane <tgl@sss.pgh.pa.us>
parent: 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 21:23 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Tom Lane <tgl@sss.pgh.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