Re: increment counter in VIEW

> Thank you very much for your link. It looks like it could do the job I want.
> Unfortunately I have problem with inserting this functionality into my VIEW
> I tried:
> CREATE OR REPLACE VIEW my_view AS SELECT
> S.a AS test,
> knoten."GEOMETRY",
> knoten.knoten,
> FROM
> generate_series(1,300) AS S(a),
> knoten knoten
> WHERE
> knoten.knoten::text = knoten_flaeche.knoten::text;
>
> Without generate_series my View produces 300 records. if I insert
> generate_series then I get 90000 because it tries all possible
> combinations with S.a. I do not know how can I limit it with WHERE.

maybe this link might help.

http://archives.postgresql.org/pgsql-sql/2006-03/msg00143.php
Regards,

Richard Broersma Jr.