Re: [SQL] Duplicates Processing

2010-10-12 Thread Rob Sargent
Gross generalization perhaps, but keep in mind what the over app/system needs of the components. Bounce those off you standard ER modeling instincts and vice versa and you have a chance! On 10/12/2010 08:19 AM, Gary Chambers wrote: > Rob, > > Thanks for your reply! > >> And to your point of sel

Re: [SQL] Duplicates Processing

2010-10-12 Thread Gary Chambers
Rob, Thanks for your reply! > And to your point of self-reference, it would be to a co-worker more > than a manager.  Managers are often not good replacements for workers. :) :) Absolutely! I was having a conversation over on #postgresql yesterday about this and, due to my inexperience with ma

Re: [SQL] Is there a conditional string-concatenation ?

2010-10-12 Thread Pavel Stehule
Hello more simply postgres=# CREATE OR REPLACE FUNCTION public.foo(a text, b text, c text) RETURNS text LANGUAGE sql AS $function$ SELECT coalesce($1 || $2 || $3, $1 || $2, $2 || $3) $function$ Regards Pavel Stehule 2010/10/12 Osvaldo Kussama : > 2010/10/12 Andrea

Re: [SQL] get attribute from XML

2010-10-12 Thread Viktor Bojović
Dear Markus, it works now. Thanx. On Tue, Oct 12, 2010 at 2:22 AM, Markus Schatten wrote: > Dear Viktor, > > 'modified' is an attribute node, so you need to use the @ sign to > acquire its value: > > mschatte=# select xpath( '//entry/@modified', ' modified="2009-07-07" dataset="S" created="2009-0