Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-03 Thread Merlin Moncure
On Thu, Sep 3, 2009 at 12:48 AM, Keith Cascio wrote: > Pavel, > > On Thu, 3 Sep 2009, Pavel Stehule wrote: > >> it's not bug - PostgreSQL doesn't support parameter placeholder on this >> position. Use dynamic query instead - plpgsql statement EXECUTE. > > Thank you for your reply.  I appreciate you

Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-03 Thread Pavel Stehule
2009/9/3 Robert Haas : > On Sep 2, 2009, at 11:27 PM, Pavel Stehule wrote: > >> Hello >> >> it's not bug - PostgreSQL doesn't support parameter placeholder on >> this position. Use dynamic query instead - plpgsql statement EXECUTE. > > It may not be a bug exactly, but it sure isn't a feature. I h

Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-03 Thread Robert Haas
On Sep 2, 2009, at 11:27 PM, Pavel Stehule wrote: Hello it's not bug - PostgreSQL doesn't support parameter placeholder on this position. Use dynamic query instead - plpgsql statement EXECUTE. It may not be a bug exactly, but it sure isn't a feature. ...Robert -- Sent via pgsql-bugs mail

Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-03 Thread Keith Cascio
Pavel, On Thu, 3 Sep 2009, Pavel Stehule wrote: > 2009/9/3 Keith Cascio : > > Why should it succeed with "bar" but not with "foo"? > > because bar isn't declared as variable I understand now. returns table(v1 t1, v2 t2,...) is equivalent to declaring OUT parameters, therefore "foo" is an out

Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-03 Thread Pavel Stehule
2009/9/3 Keith Cascio : > Pavel, > > On Thu, 3 Sep 2009, Pavel Stehule wrote: > >> it's not bug - PostgreSQL doesn't support parameter placeholder on this >> position. Use dynamic query instead - plpgsql statement EXECUTE. > > Thank you for your reply.  I appreciate your suggestion, but it still se

Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-02 Thread Keith Cascio
Pavel, On Thu, 3 Sep 2009, Pavel Stehule wrote: > it's not bug - PostgreSQL doesn't support parameter placeholder on this > position. Use dynamic query instead - plpgsql statement EXECUTE. Thank you for your reply. I appreciate your suggestion, but it still seems like a bug to me. Please co

Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-02 Thread Pavel Stehule
Hello it's not bug - PostgreSQL doesn't support parameter placeholder on this position. Use dynamic query instead - plpgsql statement EXECUTE. regards Pavel Stehule 2009/9/3 Keith Cascio : > > The following bug has been logged online: > > Bug reference:      5032 > Logged by:          Keith Casc

[BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-02 Thread Keith Cascio
The following bug has been logged online: Bug reference: 5032 Logged by: Keith Cascio Email address: ke...@cs.ucla.edu PostgreSQL version: 8.4.0 Operating system: CentOS 5.3 (Linux) Description:unexpected syntax error for plpgsql function returns table Details: Do t