Re: [SQL] EXECUTE with SELECT INTO variable, or alternatives

2005-09-30 Thread Michael Fuhr
On Fri, Sep 30, 2005 at 03:59:06PM -0500, Thomas F. O'Connell wrote: > Per the docs: > > "The results from SELECT commands are discarded by EXECUTE, and > SELECT INTO is not currently supported within EXECUTE. So there is no > way to extract a result from a dynamically-created SELECT using the

Re: [SQL] EXECUTE with SELECT INTO variable, or alternatives

2005-09-30 Thread Thomas F. O'Connell
Per the docs: "The results from SELECT commands are discarded by EXECUTE, and SELECT INTO is not currently supported within EXECUTE. So there is no way to extract a result from a dynamically-created SELECT using the plain EXECUTE command. There are two other ways to do it, however: one is

Re: [SQL] combination of function to simple query makes query slow

2005-09-30 Thread Jaime Casanova
On 9/30/05, jan aerts (RI) <[EMAIL PROTECTED]> wrote: > Hi, > > I'm having some problems in combining a function within a standard > query. > > I basically have two tables (see between hashes below): > * alias_table: objects can have different names (e.g. name1 is an alias > of name2, and name3 is

[SQL] combination of function to simple query makes query slow

2005-09-30 Thread jan aerts (RI)
Hi, I'm having some problems in combining a function within a standard query. I basically have two tables (see between hashes below): * alias_table: objects can have different names (e.g. name1 is an alias of name2, and name3 is an alias of name4) * mapping_table: shows objects that 'lead to' oth

Re: [SQL] EXECUTE SELECT INTO... last one!

2005-09-30 Thread Mario Splivalo
On Fri, 2005-09-30 at 02:34 -0600, Michael Fuhr wrote: > On Fri, Sep 30, 2005 at 10:00:35AM +0200, Mario Splivalo wrote: > > PgSql8.1beta2 gives me this: > > > > ERROR: EXECUTE of SELECT ... INTO is not implemented yet > > CONTEXT: PL/pgSQL function "_rndbroj" line 5 at execute statement > > Co

Re: [SQL] EXECUTE SELECT INTO... last one!

2005-09-30 Thread Michael Fuhr
On Fri, Sep 30, 2005 at 10:00:35AM +0200, Mario Splivalo wrote: > PgSql8.1beta2 gives me this: > > ERROR: EXECUTE of SELECT ... INTO is not implemented yet > CONTEXT: PL/pgSQL function "_rndbroj" line 5 at execute statement Could you post a simple example of what you're trying to do? The follo

[SQL] EXECUTE SELECT INTO... last one!

2005-09-30 Thread Mario Splivalo
PgSql8.1beta2 gives me this: ERROR: EXECUTE of SELECT ... INTO is not implemented yet CONTEXT: PL/pgSQL function "_rndbroj" line 5 at execute statement Shall I forget about this once and for all (and use FOR construct), or there is a chance that will be 'fixed'? Mario -- Mario Splival