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
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
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
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
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
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
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
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
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
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
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
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
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
>
"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
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
15 matches
Mail list logo