[SQL] evaluating values of attributes from computed attribute names in trigger function

Hi, I need to find all changed fields in a trigger function. I found out how to get the names of all attributes within plpgsql, but I cannot get the value of NEW and OLD for the attribute with that name. That is: assume there is NEW.foo and OLD.foo let the name 'foo' be computed and stored in

[SQL] possible to lock a single row in table?

Hello! i have a lots of threads that work on a table, making insertions, updates removes. now i certain cases its important to keep data integrity, so i looked into locks all i found was a lock function that locks the entire table now even in shared mode, if i understand it well th

[SQL] set datestyle to European PROBLEM

I have the defaul installation of postgres 7.0.3 and on another machine 7.1.2 on redhat 7.1 I cannont get the date in correct form: dbme=# select data_ar from equipment limit 5; data_ar 2001-11-05 2001-05-17 2001-05-28 2001-05-28 2001-05-22 (5 rows) then: dbme=# set dat

Re: [SQL] possible to lock a single row in table?

On Wed, 20 Jun 2001, Bruno Boettcher wrote: > i have a lots of threads that work on a table, making insertions, > updates removes. > > now i certain cases its important to keep data integrity, so i looked > into locks What kind of data integrity are you trying to implement? > all i fo

[SQL] Extracting date from epoche

Hi I have some data  that is  supose to be  a date but in ecpoche format. How can I reonvert  it to data format. Thanks in advance for help. Regards, --  Najm Hashmi Tel:514-271-9791 www.mondo-live.com www.flipr.com  

[SQL] Functions and Triggers

Title: Functions and Triggers Is there anyone that can point me into the right direction for creating a function and trigger that will do something along these lines: I have a table that has router card types and a status on them: TEST_RECORD    CARD                STATUS 1

[SQL] Functions and Triggers

Title: Functions and Triggers Is there anyone that can point me into the right direction for creating a function and trigger that will do something along these lines: I have a table that has router card types and a status on them: TEST_RECORD    CARD                STATUS 1

[SQL] How to build a TRIGGER in POSTGERSQL

Title: How to build a TRIGGER in POSTGERSQL    Hi ,   I need some help in  building  trigger and information about sysdate (System date), any help will be appreciate.    1) I need to build a trigger that every time I insert into the table  one of the columns will  get +1 numb

[SQL] pl/pgsql question (functions)

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

Re: [SQL] set datestyle to European PROBLEM

Alessandro Rossi wrote: > I have the defaul installation of postgres 7.0.3 and on another machine > 7.1.2 on redhat 7.1 > > I cannont get the date in correct form: . > Is this a bug ? > > I think i should get dd-mm-yyy date format and not -mm-dd > > Is postgres using ISO date format as

Re: [SQL] How to check if a table exists from functions.

On Tue, 19 Jun 2001, Mikael Kjellström wrote: > > Maybe I am doing this the wrong way, but how do I check if a table exist? > > This works from psql: > > select > relname > from > pg_class > where > relname = 'tablename' > > > But if I try to do the same from a PL/PGSQL stored procedu

[SQL] commentds on redhats new database

hello: i thought id find out what people think about this: http://www.zdnet.com/zdnn/stories/news/0,4586,2778706,00.html?chkpt=zdnn_rt_latest which basically points out that redhat will be making their own database based off of postgres7.1 my main concern is that this could cause some sort of s

Re: [SQL] commentds on redhats new database

On Wed, Jun 20, 2001 at 03:28:34PM -0700, clayton cottingham wrote: > hello: > > i thought id find out what people think about this: > http://www.zdnet.com/zdnn/stories/news/0,4586,2778706,00.html?chkpt=zdnn_rt_latest > > which basically points out that redhat will be making their own database >

Re: [SQL] commentds on redhats new database

"Ross J. Reedstrom" <[EMAIL PROTECTED]> writes: >> could [a fork] potentially happen? > Sure, we're BSD, so they're under no obligation to share any code changes > with us. I really doubt that RedHat is silly enough to want to fork the code. They haven't forked Linux, gcc, gdb, etc, but have bee

Re: [SQL] commentds on redhats new database

On Thu, Jun 21, 2001 at 01:32:10AM -0400, Tom Lane wrote: > "Ross J. Reedstrom" <[EMAIL PROTECTED]> writes: > >> could [a fork] potentially happen? > > > Sure, we're BSD, so they're under no obligation to share any code changes > > with us. > > I really doubt that RedHat is silly enough to want