public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jared H. Hudson <[email protected]>
To: [email protected]
Subject: SELECT'ing a function call
Date: Fri, 6 Jul 2001 12:25:21 -0500
Message-ID: <[email protected]> (raw)


I would like to be able to define a table with 1 column containing user
names,
and the next column being a dynamically generating function that returns a
user's quota.

I think I see how to create the shared object, and the SQL function. But,
how
do I create a table that uses a function for a column based on the value of
another
column.

For example, I tried:

CREATE TABLE test (
    num1 INTEGER,
    num2 INTEGER DEFAULT add_one('num1')
);

But that said that pg_atoi doesn't understand num1 -- so apprenting atoi is
interpreting
num1 as a string, so I tried ...DEFAULT add_one(num1) which gave a different
error.

Is this even possible? To have a "trigger" based on a select statement. I
looked at the SQL
TRIGGER command and it seems to only work for INSERT, UPDATE and DELETE. I
need a "trigger"
for SELECT's.

Thanks,
Jared H.

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: SELECT'ing a function call
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox