Re: Some help with functions-syntax

From: "Jan Meyland Andersen" <jma(at)agile(dot)dk>
To: "John DeSoi" <desoi(at)pgedit(dot)com>
Cc: "Jan Meyland Andersen" <jma(at)agile(dot)dk>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Some help with functions-syntax
Date: 2007-01-18 07:38:56
Message-ID: 62559.82.143.192.130.1169105936.squirrel@mail.agile.dk
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> There are two forms to iterate over the query:
>
> 1. FOR target IN query LOOP
> 2. FOR target IN EXECUTE text_expression LOOP

Thanks for your answer.

> My suggestion is to eliminate the string you created (_WHERECLAUSE) and
> add the proper conditions to the query expression you already have.

But the problem here is that the where-clause depends on the relkind. That
is why I'm trying to solve the problem this way.

How do I then write EXECUTE queries on multiple lines, if I go with this
solution?

Regards

Jan

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message John DeSoi 2007-01-18 13:47:19 Re: Some help with functions-syntax
Previous Message John DeSoi 2007-01-18 00:50:40 Re: Some help with functions-syntax