Re: [GENERAL] pre-parser query manipulation

2007-03-15 Thread Tom Lane
Randall Smith <[EMAIL PROTECTED]> writes: > I'm at a loss as to how to remove the OF clause at the server. It it > possible to do it with a rule? No, because the syntax error will occur long before any rule has a chance to get involved. You'd have to actually hack the C code (see transformLocki

Re: [GENERAL] pre-parser query manipulation

2007-03-15 Thread Randall Smith
Erik Jones wrote: This may be a dupe. I sent and had some issues with my mail client and afterwards it was sitting all alone in my outbox, if you've already seen this, sorry for the resend... On Mar 14, 2007, at 2:08 PM, Randall Smith wrote: Hi, I'm attempting to process a query written in

Re: [GENERAL] pre-parser query manipulation

2007-03-14 Thread Randall Smith
Erik Jones wrote: This may be a dupe. I sent and had some issues with my mail client and afterwards it was sitting all alone in my outbox, if you've already seen this, sorry for the resend... On Mar 14, 2007, at 2:08 PM, Randall Smith wrote: Hi, I'm attempting to process a query written in

Re: [GENERAL] pre-parser query manipulation

2007-03-14 Thread Erik Jones
This may be a dupe. I sent and had some issues with my mail client and afterwards it was sitting all alone in my outbox, if you've already seen this, sorry for the resend... On Mar 14, 2007, at 2:08 PM, Randall Smith wrote: Hi, I'm attempting to process a query written in the form: S

[GENERAL] pre-parser query manipulation

2007-03-14 Thread Randall Smith
Hi, I'm attempting to process a query written in the form: SELECT fields FROM table WHERE conditions FOR UPDATE OF field_name when Postgresql supports: SELECT fields FROM table WHERE conditions FOR UPDATE OF table_name I'd like to remove the OF clause in the case only one table is que