Re: Another 7.1 EXECUTE Question

From: Brian Troxell <trox(at)mindspring(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Another 7.1 EXECUTE Question
Date: 2001-01-05 18:43:16
Message-ID: 3A5615C4.88929DEE@mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Brian Troxell wrote:

> I'm getting an error when forming SELECT statements using the new 7.1
> EXECUTE command. The error states, simply, that there was an unexpected
> SELECT within the EXECUTE command.
>
> Which leads me to ask: can I actually form SELECT statements using
> EXECUTE, or is there something else I need to be doing?
>
> Thanks in advance.

Cleverly, I left out a lot of details.

I was actually trying to use EXECUTE to call another defined function,
creating that function name on the fly. Is this possible at all?

I've even gone so far as to hard-code the execute statement with the
desired function (execute ''select function_name(2)'';) and that also gave
the same error.

Thanks again! (in advance)

-Brian Troxell
trox(at)mindspring(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Davis 2001-01-05 18:44:17 RE: Using Postgres with Access 2000
Previous Message Scott Teglasi 2001-01-05 18:34:35 RE: Using Postgres with Access 2000