Re: insert serial numbers

Albert Vernon Smith wrote:
> CREATE FUNCTION "return_one_id" () RETURNS "trigger" AS '

Is there any reason you force your identifiers to be case sensitive?

 > CREATE TRIGGER return_one_id BEFORE INSERT OR UPDATE ON two FOR EACH
 >> CREATE TABLE "one" (
 >>     "one_id" BIGSERIAL,
 >>     "text" text NOT NULL,
 >>     CONSTRAINT "iu_text" UNIQUE (text)
 >> )
 >> CREATE TABLE "two" (
 >>     "two_id" BIGSERIAL,
 >>     "text" text NOT NULL,
 >>     "one_id" bigint,

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

//Showing your Vision to the World//