Re: [SQL] Functions return a select in a table, which data type I

2004-10-22 Thread Markus Bertheau
Ð ÐÐÐ, 22.11.2004, Ð 00:07, Andrà Toscano ÐÐÑÐÑ: > Hello, friends. > > If anybody can help, how can I do a FUNCTION return a result from a > SELECT in a table in PostgreSQL? > My Problem is the RETURN TYPE from a FUNCTION, I donÂt know what I have > to use to return the data as a select result.

Re: [SQL] Finding duplicated values

2004-10-22 Thread Christoph Haller
Kent Anderson wrote: > I have a few tables that have duplicated values from an import from a > different database. I have two keys I tried to set as primary and got > an error ERROR: could not create unique index > DETAIL: Table contains duplicated values.Is there some join I can use > to compa