Re: defaults referencing other columns? - Mailing list pgsql-novice

Can a default value reference the value specified for one of the other
columns in the insert?

If you have like:

CREATE TABLE foo ( id INT PRIMARY KEY,
                  name TEXT NOT NULL,
                  bar TEXT );

can foo.bar have a default that is the result of calling a function on
the value currently being inserted into foo.id or foo.name?

I'd like something along the lines of:

                  bar TEXT DEFAULT somefunc(id)

but how does one specify that the value to be passed to the funtion is
the exact value that insert is inserting into the foo.id column?

And will it work even when the value being inserted into foo.id is
itself the result of a function?  (I presume so, but ....)

-JimC
--
James Cloos <cloos@jhcloos.com>         OpenPGP: 0xED7DAEA6

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly