Re: [SQL] What is a "tuple"

2001-06-22 Thread Kristoff Bonne
Greetings, (and also Alex) On Fri, 22 Jun 2001, Josh Berkus wrote: > > Excuse my lack my 'database'-jargon, but what is a 'tuple'? > Also known as a "Record", or a "Row". The word "tuple" is used because > it can refer to a row returned as part of a result set as well as a > record in a table.

[SQL] What is a "tuple"

2001-06-22 Thread Kristoff Bonne
Greetings, I've been on this list for just a couple of days now; and I've seen the word 'tuple' here a couple of times. Excuse my lack my 'database'-jargon, but what is a 'tuple'? Cheerio! Kr. Bonne. -- KB905-RIPE Belgacom IP networking (c=be,a=rtt,p=belg

Re: [SQL] Changing PL/pgSQL triggers

2001-06-22 Thread Kristoff Bonne
Greetings, On Thu, 21 Jun 2001, Josh Berkus wrote: >> What's the easiest way to modify or view a function written in >> PL/pgSQL? I've been using pg_dump to get the original function, then >> dropping and creating the function and trigger after making a change. >> Is there an easier way? > Well

[SQL] pl/pgsql question (functions)

2001-06-20 Thread Kristoff Bonne
Greetings, I am new to pl/pgsqm (I did some SQL programming at school, now 8 years ago so that part is rusty too ;-)) Anycase, I have a question concerning creating your own functions in pl/pgsql. This is my situation: I have two tables: - 'hosts': containing 'hostname' (primary key) and 'ip_a