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

Re: [PLPGSQL] PERFORM into an EXECUTE allowed ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruno Baguette <bruno(dot)baguette(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [PLPGSQL] PERFORM into an EXECUTE allowed ?
Date: 2008-10-27 04:16:24
Message-ID: (view raw or whole thread)
Lists: pgsql-general
Bruno Baguette <bruno(dot)baguette(at)gmail(dot)com> writes:
>       || ' FROM ' || quote_ident(TG_RELNAME)
>       || ' GROUP BY ' || quote_ident(column_name_to_check)
>       || ' HAVING COUNT(*) > 1';

PERFORM is a plpgsql keyword, not a SQL keyword, so it's not surprising
that this fails.  What I'm wondering is what exactly you hope the above
will accomplish?  Why would you want to execute this query only to have
the results discarded?

			regards, tom lane

In response to


pgsql-general by date

Next:From: Ron MayerDate: 2008-10-27 07:34:16
Subject: Re: Are there plans to add data compression feature to postgresql?
Previous:From: Bruno BaguetteDate: 2008-10-27 03:39:03
Subject: [PLPGSQL] PERFORM into an EXECUTE allowed ?

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