> 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,
> generate_series(1,300) AS S(a),
> knoten knoten
> 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.
Richard Broersma Jr.
In response to
pgsql-novice by date
|Next:||From: Petronenko D.S.||Date: 2006-07-12 16:39:05|
|Subject: postgre linkage with non-postgre db|
|Previous:||From: Oleg||Date: 2006-07-12 15:03:01|
|Subject: Re: increment counter in VIEW|