pgsql-sql-ow...@postgresql.org schrieb am 01.03.2012 09:16:53:
> From: Frank Lanitz
> To: pgsql-sql@postgresql.org,
> Date: 01.03.2012 09:16
> Subject: Re: [SQL] No sort with except
> Sent by: pgsql-sql-ow...@postgresql.org
>
> Am 01.03.2012 09:13, schrieb reto.buc...@wsl.ch:
> > Dear all,
> >
Dear all,
When I run the following SQL with PostgreSQL 9.1:
--
SELECT DISTINCT ON (pernr) pernr, vorna, nachn, eindt, ausdt, updat,
status
FROM person
WHERE eindt <= TO_CHAR(CURRENT_DATE,'MMDD')
AND ausdt >= TO_CHAR(CURRENT_DATE,'MMDD')
ORDER BY pernr, eindt DESC;
--
it wo
