Re: [SQL] Formatting zeroes

2002-09-16 Thread Bruce Momjian
Josh Berkus wrote: > Ludwig, > > > I'm trying to use SQL to generate a formatted > > report. The "to_char(numeric,'FM9,999,999,999.99')" > > function works when I use it format numbers with > > decimal points and appropriate commas. > > Is there a format specifier in the to_char function > >

Re: [SQL] Dublicates pairs in a table.

2002-09-16 Thread Ries van Twisk
Richard, do you suggest using a stored procedure to handle this? I do expect that the table will be large (for me large is a around 1-2 records, the table as more columns but I only need the restriction on c1 & c2) but I don’t expect lots of inserts and deletes. Data entry will be done us