Postgres Pro
Downloads
Home   >   mailing lists

trigger - dynamic WHERE clause - Mailing list pgsql-general

From Tarlika Elisabeth Schmitz
Subject trigger - dynamic WHERE clause
Date
Msg-id 20110522181821.593c60c8@dick.coachhouse
Whole thread Raw
Responses Re: trigger - dynamic WHERE clause  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Tree view 
EXECUTE 'SELECT 1 FROM ' || TG_TABLE_NAME || ' WHERE ' || whereclause
|| ' FOR UPDATE;';

I am generating the whereclause dynamically as the number of columns
queried varies.

Am I right in assuming that I cannot use EXECUTE ... USING in this
scenario?

--

Best Regards,
Tarlika Elisabeth Schmitz

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: how to start a procedure after postgresql started.
Next
From: Darren Duncan
Date:
Subject: Re: how to start a procedure after postgresql started.