rules question

From: ed despard <despareg(at)clarkson(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Cc: pgsql-sql(at)postgresql(dot)org
Subject: rules question
Date: 2003-04-30 04:00:51
Message-ID: 55369696-7AC0-11D7-B730-0003938ABE54@clarkson.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

hi, i have a table named pursuit which has no data in it, currently to
get data for the table i have a function that i call like: select *
from pursuit_select_function(raceid), but i put in the raceid that im
selecting for. i would like to be able to treat this table like a view
and make a query like select * from pursuit where raceid=9 or somthing
and have a rule rewrite this into the function call. is there a way to
have a rule that rewrites the query based on the qualifier of the query?

the reason im not just using a normal view is that i have a sequence
that needs to be reset before each select, so the
pursuit_select_function resets the sequence and does the select query.

thanks.
ed

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-04-30 04:14:34 Re: Optimizer not using index on 120M row table
Previous Message Tom Lane 2003-04-30 03:58:03 Re: dump/restore to 7.4devel giving "[archiver (db)] error returned by PQputline"

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-04-30 04:10:37 Re: Making "SECURITY DEFINER" procedures.. - SOLVED
Previous Message David Durst 2003-04-30 01:00:29 unsubscribe