[SQL] Conditional SQL query

2000-11-04 Thread Indraneel Majumdar
Hi, how can I insert a record after checking whether one of the fields has a certain value or not? eg: if table(col1)='value' insert into table values (x,x,x) I am using perl interface. Is there any way to define a function to take table name as an argument? (eg: select * from $table) I tried b

[SQL] PLPGSQL performance

2000-11-04 Thread kovacsz
I'm not sure I will be correct. Tom, could you please check this? I usually work with many PLPGSQL functions. They are mostly same fast like SQL functions. But now, I found a difference. My SQL function was much more faster than the PLPGSQL one. I signed the "slow" statement in the PLPGSQL functi

[SQL] Meaning of "REMINDER from pgsql..."

2000-11-04 Thread [EMAIL PROTECTED]
What's the meaning of the "REMINDER from pgsql ..." message? I checked the page, and apparently everybody on the list got the message. Should we accept or reject the action? Troy