Re: Abfrage nach einer Reihe von Jahren

Gunnar Oehmichen <[email protected]> wrote:

> WHERE
>   EXTRACT (year from mzb.date) = 1999 AND
>   EXTRACT (year from mzb.date) = 2000 AND
>   EXTRACT (year from mzb.date) = 2001 AND
>   EXTRACT (year from mzb.date) = 2002

error in mod_logic:

Ein Datum kann nicht gleichzeitig in mehreren Jahren sein. Ich denke, Du
suchst BETWEEN:

where mzb.date between '1999-01-01' and '2002-12-31'

oder so in der Art.


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°


-- 
Sent via pgsql-de-allgemein mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-de-allgemein