Re: [SQL] to listadmin

On Tue, Jun 07, 2005 at 13:54:21 +0530, Kenneth Gonsalves <[EMAIL PROTECTED]> wrote: > On Tuesday 07 Jun 2005 1:35 pm, Richard Huxton wrote: > > I'm not sure it is from the list - it appears to be something setup > > by [EMAIL PROTECTED] > > apparently he is a member of the list - so mail from a

Re: [SQL] rule or trigger?

M.D.G. Lange wrote: In order for a "dictionary" system I have created the following system: tbllanguages - ID - name Primary key ( ID ) tbldictionary - wordid - languageid - value Primary key ( wordid, languageid) The idea is to have a word id in several languages, so you only have to look up

Re: [SQL] to listadmin

Achilleus Mantzios <[EMAIL PROTECTED]> writes: > O Kenneth Gonsalves Ýãñáøå óôéò Jun 7, 2005 : >> On Tuesday 07 Jun 2005 1:35 pm, Richard Huxton wrote: >>> I'm not sure it is from the list - it appears to be something setup >>> by [EMAIL PROTECTED] >> >> apparently he is a member of the list - so

Re: [SQL] rule or trigger?

On Tue, 7 Jun 2005, M.D.G. Lange wrote: > It is not possible to create a constraint Foreign key for "wordid". No > problem there, but I want to be certain that a given wordid exists in > tbldictionary. > Would I have to create a "RULE" or a "TRIGGER" to be certain that the > wordid is existing in

[SQL] rule or trigger?

In order for a "dictionary" system I have created the following system: tbllanguages - ID - name Primary key ( ID ) tbldictionary - wordid - languageid - value Primary key ( wordid, languageid) The idea is to have a word id in several languages, so you only have to look up the word id and give

[SQL] Can we stop that?

Can please some of the administrators remove that member or what-o-else -Original Message-From: AntiSpam UOL [mailto:[EMAIL PROTECTED]Sent: Dienstag, 07. Juni 2005 11:22To: KÖPFERL RobertSubject: RE: Re: [SQL] SQL equivalent to nested loop ANTISPAM UOL »

Re: [SQL] SQL equivalent to nested loop

Instead of tablenames just use functions (tablefunctions) like my example select a."Id", a."Code" from "GetLanguages"() a, "GetLanguages"() b "2","en" "2","en" "1","de" "1","de" |-Original Message- |From: Markus Bertheau [mailto:[EMAIL PROTECTED] |Sent: Dienstag, 07. Juni 2005 01:17 |To:

Re: [SQL] to listadmin

O Kenneth Gonsalves έγραψε στις Jun 7, 2005 : > On Tuesday 07 Jun 2005 1:35 pm, Richard Huxton wrote: > > I'm not sure it is from the list - it appears to be something setup > > by [EMAIL PROTECTED] > > apparently he is a member of the list - so mail from any 'untrusted' > guy like me gets this

Re: [SQL] to listadmin

On Tuesday 07 Jun 2005 1:35 pm, Richard Huxton wrote: > I'm not sure it is from the list - it appears to be something setup > by [EMAIL PROTECTED] apparently he is a member of the list - so mail from any 'untrusted' guy like me gets this message. (anyone else getting it?) -- regards kg http://

Re: [SQL] to listadmin

Kenneth Gonsalves wrote: hi, every time i post to this list i get a copy of the message below - could the listadmin do something (or is there something i have to do?) I'm not sure it is from the list - it appears to be something setup by [EMAIL PROTECTED] You´ve just sent a message to [EM

[SQL] to listadmin

hi, every time i post to this list i get a copy of the message below - could the listadmin do something (or is there something i have to do?) -- Forwarded Message -- Subject: RE: Re: [SQL] preventing deletion of a row Date: Tuesday 07 Jun 2005 12:24 pm From: AntiSpam UOL <[EM

Re: [SQL] What is faster?

O ON.KG έγραψε στις Jun 7, 2005 : > RH> ON.KG wrote: > >> Hi All! > >> > What is faster - SLECTion data from one large table (200 000 - 300 000 > records), or SELECTion from a few small tables (example, 2 tables 150 > 000 records each)? > >> > >> For example i have two large tables >