Is there anyway to declare a constant that you can then use within a postgresql 'session', i am connecting from a PHP based application and trying to integrate another.

What I want to be able to do is setup a rule on another table so that whenever a query is run on the table it appends another value to the query.

i.e i want to be able to do:

'SET someconstant an_id=1;'

Then with a rule, running:

SELECT * FROM a_table

would become:

SELECT * FROM a_table WHERE id=a_id

is this possible?

Thanks

Jake

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to