Postgres Pro
Downloads
Home   >   mailing lists

pre-parser query manipulation - Mailing list pgsql-general

From Randall Smith
Subject pre-parser query manipulation
Date
Msg-id et9h7p$eid$1@sea.gmane.org
Whole thread Raw
Responses Re: pre-parser query manipulation  (Erik Jones <erik@myemma.com>)
List pgsql-general
Tree view 
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 queried.

Anyone know of a solution to this?

Randall

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: quoted identifier behaviour
Next
From: Jorge Godoy
Date:
Subject: Re: Multiple TRIGGERs and OLD versus NEW "records"