[SQL] Updating one table with data from another

Hey all, There are two things I need to do: 1. Update existing rows with new data 2. Append new rows I need to update only some of the fields table1 with data from table2. These tables have the exact same fields. So here's what I have currently for appending new rows (rows where CID does not cur

[SQL] query faster using LEFT OUTER join?

t; Index Scan using context_pkey on context c (cost=0.00..6.81 rows=1 width=18) (actual time=0.008..0.009 rows=1 loops=770) Index Cond: (i.context_id = c.context_id) Thanks for your help, Drew ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [SQL] How convert UNICODE

How about pg_dump the data from your old database, then load it into your new database which is using UTF8? Drew On Nov 17, 2006, at 9:09 AM, lms wrote: Hello I have 2 databases with same table. First database is in UNICODE, second in SQL_ASCII. 4 columns from first database I must

[SQL] How to find missing values across multiple OUTER JOINs

, to avoid some associative problem. Do you see what I'm doing wrong? Thanks for the help, Drew ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [SQL] How to find missing values across multiple OUTER JOINs

Thanks! That was it. Drew On Jun 6, 2007, at 1:45 AM, Ragnar wrote: On þri, 2007-06-05 at 23:55 -0700, Drew wrote: I'm having troubles using multiple OUTER JOINs, which I think I want to use to solve my problem. My problem is to find all non-translated string values in our transla

[SQL] logging messages from inside pgPLSQL routine?

I'mm trying to debug something inside my PLSQL routine. How do I print out error messages from inside my function? Thanks, Drew ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "