Re: [GENERAL] Creating a session variable in Postgres

m: "Mike Mascari" <[EMAIL PROTECTED]> To: "Nagib Abi Fadel" <[EMAIL PROTECTED]> Cc: "Manfred Koizar" <[EMAIL PROTECTED]>; "Bruce Momjian" <[EMAIL PROTECTED]>; "generalpost" <[EMAIL PROTECTED]> Sent: Friday, June 04, 2004 11

Re: [GENERAL] Creating a session variable in Postgres

- Original Message - From: "Nagib Abi Fadel" <[EMAIL PROTECTED]> To: "Manfred Koizar" <[EMAIL PROTECTED]> Cc: "Mike Mascari" <[EMAIL PROTECTED]>; "Bruce Momjian" <[EMAIL PROTECTED]>; "generalpost" <

Re: [GENERAL] Creating a session variable in Postgres

So considering those facts, it would be better to use the Sequence Method, since it would only require cleaning up one table Or is there anything else i am missing ??? - Original Message - From: "Manfred Koizar" <[EMAIL PROTECTED]> To: "Nagib Abi Fadel&qu

Re: [GENERAL] Creating a session variable in Postgres

temp will be created and X inserted in it. I solved my problem but it does not seem like a "clean way". Any ideas ?? I have now a DYNAMIC view - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "Nagib Abi Fadel" <[EMAIL PROTECT

[GENERAL] Creating a session variable in Postgres

Is it possible to create a session variable for each user in Postresql ??   Thx

[GENERAL] ON DELETE RULE problem

Hi,   I need to run the following  delete command on a view table1_v : " delete from table1_v where table1_var1=$table1_var1 and table1_var2 not in (select  t2.id from table2_v t2,table3_v t3    where t3.vers_id=t2.vers_id and t3.var3=$var3); " I have not been able to figure out how to crea

[GENERAL] XOR logical operator

Is there a XOR logical operator in Postgresql, or a function for XOR ?? I only found in the docs a Binary XOR (#). I need to do the following checkup: (field1 is NULL XOR field2 is NULL XOR filed3 is NULL) i can't right it like this: ( (field1 is NUll or field2 is NUll) and (field1 is NUll or fi

[GENERAL] Triggers tutorial

Hi, is there any good trigger tutorial on the net ?? thx __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com ---(end of broadcast)--- TIP 9: the planner will ignore you

Re: [GENERAL] Cross database foreign key workaround?

You can try to use dblink (function returning results from a remote database)and create some triggers with it in order to make remote referential integrity. Or if there's a lot of links between the tables in the 2 databases it may be better to use one database. --- David Busby <[EMAIL PROTECT

Re: [GENERAL] refential integrity to multiple tables ??

s     - Original Message ----- From: Nagib Abi Fadel To: [EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 7:53 AM Subject: [GENERAL] refential integrity to multiple tables ?? HI,   let's say i have a tansaction table called TRANSACTION (transaction_id,amount,type,type_id)   Let&#x

Re: [GENERAL] refential integrity to multiple tables ??

--- Richard Huxton <[EMAIL PROTECTED]> wrote: > On Wednesday 08 October 2003 06:53, Nagib Abi Fadel > wrote: > > HI, > > > > let's say i have a tansaction table called > TRANSACTION > > (transaction_id,amount,type,type_id) > > > > Let

[GENERAL] refential integrity to multiple tables ??

HI,   let's say i have a tansaction table called TRANSACTION (transaction_id,amount,type,type_id)   Let's say a transaction can have multiple types: TYPE1, TYPE2 for example.   EACH type has his own definition and his own table.   Every transaction has a type that could be type1 or type2 that's why

[GENERAL] databse design tutorial

Hi everybody,   i need a free tutorial on database design can any help ??   thx Do you Yahoo!? The New Yahoo! Shopping - with improved product search