Skip site navigation (1) Skip section navigation (2)

Re: increment counter in VIEW

From: Richard Broersma Jr <rabroersma(at)yahoo(dot)com>
To: Oleg <evdakov(at)iwg(dot)uka(dot)de>, pgsql-novice(at)postgresql(dot)org
Subject: Re: increment counter in VIEW
Date: 2006-07-12 15:29:47
Message-ID: 20060712152947.88707.qmail@web31804.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
> 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.

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: OlegDate: 2006-07-12 15:03:01
Subject: Re: increment counter in VIEW

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group