em stands for easy money
update tbl1
set col3=em.col3,col4=em.col4,col5=em.col5
from
(select col3, col4,col5 from tbl2 where col1=criteria) em
Regards,
Justin Tocci
Programmer
www.workflowproducts.com
7813 Harwood Road
North Richland Hills, TX 76180
phone 817-503-9545
skype justintocci
On May
Il giorno 24/feb/08, alle ore 04:53, justin tocci ha scritto:
In its most basic form a great tool would just start as a pl/pgsql
or pl/perl function that could be used to call a table and have it
output a batch of records to an editable html form or a colored pdf
for nice reports
.
Anyone know of anything like this?
Best Regards,
Justin Tocci - www.unirev.com
7813 Harwood Road, North Richland Hills, TX 76180
cell 817-988-7758 - land 817-503-9545
--
I am curious to know if there is anything sort of like APEX or Html DB
in the Oracle world
[] to int2vector
Any help here would be appreciated.
justin tocci
fort worth, tx
---(end of broadcast)---
TIP 8: explain analyze is your friend
#!/usr/bin/perl -wuse strict;# This program turns text files with TABLE definitions# clipped from PGADMIN into VIEWs with a pre-pended 't'.## All VIEWs get a full set of rules and permissions and assume the first column is the primary key.# # To use:# put this script into a text file and save
don't show up either. Does pg_depend
not have records for dependent views? If not, how is it
done?
---
justin
tocci
Fort Wayne, IN
When my RULE takes
the form of:
CREATE
RULE name AS ON INSERT TO tableDO INSTEAD ( UPDATE query ;INSERT
query);
The INSERT query doesn't fire and
there is no error. Putting the INSERT first allows them to both fire. Can anyone
tell me why? I think it has something to do with *NEW* and
