Re: [SQL] How to check: is some key referenced from sometable

2003-08-14 Thread Jonathan Gardner
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Saturday 09 August 2003 14:44, eVl One wrote: > So I need: >"silent delete" - i.e. when trying to DELETE row from A I'll not > fall out with "$1 referential integrity violation - key in A still > referenced from Bxx", but silently doesn't delete

Re: [SQL] How to check: is some key referenced from sometable

2003-08-14 Thread Bruno Wolff III
On Mon, Aug 04, 2003 at 11:17:56 +0300, [EMAIL PROTECTED] wrote: > Please help. > > Need a boolean function which returns true if given key in table is > referensed from another table(s). Use "exists" with a subselect. Something like: select exists(select 1 from table where table.key = 'value')

Re: [SQL] How to check: is some key referenced from sometable

2003-08-14 Thread eVl One
Hello, Bruno. You wrote 9 08 2003, 18:08:09: BWI> On Mon, Aug 04, 2003 at 11:17:56 +0300, BWI> [EMAIL PROTECTED] wrote: >> Please help. >> >> Need a boolean function which returns true if given key in table is >> referensed from another table(s). BWI> Use "exists" with a subselect. Something

[SQL] How to check: is some key referenced from sometable

2003-08-10 Thread evl
Please help. Need a boolean function which returns true if given key in table is referensed from another table(s). --- see You again when ... eVl ---(end of broadcast)--- TIP 5: Have you checked our extensiv

Re: [SQL] How to check: is some key referenced from sometable

2003-08-09 Thread Stephan Szabo
On Sun, 10 Aug 2003, eVl One wrote: > Hello, Bruno. > > You wrote 9 08 2003, 18:08:09: > > BWI> On Mon, Aug 04, 2003 at 11:17:56 +0300, > BWI> [EMAIL PROTECTED] wrote: > >> Please help. > >> > >> Need a boolean function which returns true if given key in table is > >> referensed from another tab