Re: [SQL] Union Question

Ah, ok. My bad for not reading good enough. Shaun McCloud - Software Testing Analyst GeoComm Inc. 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com Microsoft Certified Desktop Support Technician

Re: [SQL] Union Question

That would be nice to see in the documentation for dblink Shaun McCloud - Software Testing Analyst GeoComm Inc. 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com Microsoft Certified Desktop Support

Re: [SQL] Union Question

I'm trying that, but I am getting an error that says "ERROR: function dblink_connect(unknown, unknown) does not exist" Shaun McCloud - Software Testing Analyst GeoComm Inc. 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.

[SQL] Union Question

I can do this without using Slony-I to replicate the data to the administrative server? Shaun McCloud - Software Testing Analyst GeoComm Inc. 601 W. Saint Germain St., Saint Cloud, MN 56301 Office: 320.240.0040 Fax: 320.240.2389 Toll Free: 888.436.2666 click here to visit www.geo-comm.com<http:/

Re: [SQL] Blank-padding

ng that is being stored. So it is stored as "abc " instead of "abc". I don't want that padding there. I am fairly new to Postgres and have only dealt with Informix database systems, which don't store data this way. Any help is very much appreciated. Thanks, Shau

[SQL] CREATE USER in side a TRIGGER FUNCTION

wrong the the following code? shaun here is the add person trigger. CREATE FUNCTION insuser () RETURNS TRIGGER AS 'BEGIN IF NEW.role = ''clerk'' THEN EXECUTE CREATE USER NEW.login IN GROUP gp_clerk; ELSIF NEW.role = ''medic'&

[SQL] selecting problems

1 group by ca_code,ca_desc,ca_dis_cycle Thanks, Shaun ----- Shaun, <mailto:[EMAIL PROTECTED]> Phone 1-317-913-4160 Fax 1-317-913-4175 CSI - Computer Systems, Inc. <http://www.computer-systems.com/> "Dictionary is

[SQL] Failing query...

) Can someone please help me understand what I'm doing wrong. If there is no value in the select max() subselect, the query works, but if there is, it doesn't. Please CC: me to any reply as I've emailed to join the list but the reply hasn't yet reached me from majordomo. Thanks, Shaun