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
s
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. There
.
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
: UNION/INTERSECT/EXCEPT could not convert type
int2vector[] 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
escA, but I haven't been able to get dependent views to show up
at all. In fact views that depend on views 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 table DO 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* an
You are correct Tom, vtquotehistory is a view of tquotehistory, and I am
trying to log in this example. Sorry I didn't point that out. The view is a
straight view with no WHERE clause or criteria of any kind. The UPDATE does
cause the OLD record to become updated to whatever changes have been set a
